DATE_FORMAT
DATE_FORMAT (column_name,'%Y-%m-%d %H:%i')
-Mensaje original-
De: J S [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 14 de Julio de 2004 08:26 a.m.
Para:
mn_name,'%Y-%m-%d %H:%i')
-Mensaje original-
De: J S [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 14 de Julio de 2004 08:26 a.m.
Para: [EMAIL PROTECTED]
Asunto: sql function for timestamp
Hi,
What SQL function do I need to convert timestamp 200406011403 into
"2004-06-01 14:03
_FORMAT (column_name,'%Y-%m-%d %H:%i')
-Mensaje original-----
De: J S [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 14 de Julio de 2004 08:26 a.m.
Para: [EMAIL PROTECTED]
Asunto: sql function for timestamp
Hi,
What SQL function do I need to convert timestamp 200406011403 into
"2
If you have 4.1.1 or greater, you can use GET_FORMAT( timestamp, 'ISO'
).
Otherwise, I think if you just use DATE_FORMAT( timestamp, '%Y-%m-%d
%H:%i ) you will get weird values if your timestamp field doesn't
include seconds. So, either alter your field to be CONCAT( timestamp,
'00' ), or, as
#x27; function in PHP for info.
- Eve
-Original Message-
From: Chinchilla Zúñiga, Guillermo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 11:54 AM
To: J S; [EMAIL PROTECTED]
Subject: RE: sql function for timestamp
In MySQL you can do that with: DATE_FORMAT
DATE_FORMA
In MySQL you can do that with: DATE_FORMAT
DATE_FORMAT (column_name,'%Y-%m-%d %H:%i')
-Mensaje original-
De: J S [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 14 de Julio de 2004 08:26 a.m.
Para: [EMAIL PROTECTED]
Asunto: sql function for timestamp
Hi,
What SQL function
Hi,
What SQL function do I need to convert timestamp 200406011403 into
"2004-06-01 14:03" ?
Thanks,
JS.
_
Stay in touch with absent friends - get MSN Messenger
http://www.msn.co.uk/messenger
--
MySQL General Mailing List
For list a
