DATE question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Sevengraff
Forum Contributor
Posts: 232
Joined: Thu Apr 25, 2002 9:34 pm
Location: California USA
Contact:

DATE question

Post by Sevengraff »

how does it store the date, is it Y-M-D, or Y-D-M?
Elena Mitovska
Forum Newbie
Posts: 6
Joined: Mon Nov 18, 2002 3:43 am
Location: Ukraine
Contact:

Post by Elena Mitovska »

MySQL stores dates as YYYY-MM-DD :)
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
User avatar
Sevengraff
Forum Contributor
Posts: 232
Joined: Thu Apr 25, 2002 9:34 pm
Location: California USA
Contact:

Post by Sevengraff »

oh, sorry, i guess that info would have helped :)

thanks! this helps a lot!
Post Reply