Error 1064 al crear una funcion
Hola, soy nuevo y estoy manejando mysql para hacer una aplicacion.
Lo que quiero es hacer una funcion que me devuelva la hora en el formato 00:00
Tengo la sentencia la cual me devuelve que se
select concat(right(concat("0",hour(hora_turno)),2),":",right(concat("0",minute(hora_turno)),2)) from turno
pero a la hora de hacer la funcion, me tira el error
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'return (select concat(right(concat("0",hour(hora_turno)),2),":",right(concat("0"' at line 4
(0 ms taken)
Quisiera que alguien me ayudara.
Saludos desde Argentina
Subject
Views
Written By
Posted
Error 1064 al crear una funcion
13005
January 28, 2008 02:54PM
4293
January 29, 2008 08:54AM
3491
February 02, 2008 03:07PM
2604
February 02, 2008 07:09PM
2990
February 02, 2008 08:05PM
2707
February 06, 2008 12:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.