Page 1 of 1

DATE question

Posted: Sat Nov 23, 2002 1:23 am
by Sevengraff
how does it store the date, is it Y-M-D, or Y-D-M?

Posted: Sat Nov 23, 2002 4:08 am
by Elena Mitovska
MySQL stores dates as YYYY-MM-DD :)

Posted: Sat Nov 23, 2002 5:34 am
by twigletmac
and handily enables you to adjust that when you output the data:
http://www.mysql.com/doc/en/Date_and_ti ... tions.html

(This is also assuming that you are using MySQL as you don't mention which database you are interested in)

Mac

Posted: Sat Nov 23, 2002 1:38 pm
by Sevengraff
oh, sorry, i guess that info would have helped :)

thanks! this helps a lot!