Jump to content

Archived

This topic is now archived and is closed to further replies.

feri_soft

Mysq date type

Recommended Posts

how to put data into a date type field.I have no problem inputing date into a varchat field but how into a date fi eld.And how to determine the time format ?

Share this post


Link to post
Share on other sites
A DATE type column doesn't have a time element.

[code]INSERT INTO mytable (datecol) VALUES ('2006-04-19')[/code]

if you have a DATETIME column

[code]INSERT INTO mytable (datecol) VALUES ('2006-04-19 21:49:00')[/code]

Share this post


Link to post
Share on other sites
I can recommend storing all your dates and timestamp as UNIX_TIMESTAMP.

All these different time- and dateformats can get really confusing. Always use unix timestamps for al time-related operations, untill you need to display. Php's setlocale() and strftime() will then give you exactly the format you want to display.

Share this post


Link to post
Share on other sites
I was born in Jan, 1949. Try storing my dob in a unix timestamp.

Share this post


Link to post
Share on other sites
S o i must add this [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--](datecol)[/quote] i n my query ?? ;)

Share this post


Link to post
Share on other sites
[!--quoteo(post=367324:date=Apr 21 2006, 02:22 PM:name=feri_soft)--][div class=\'quotetop\']QUOTE(feri_soft @ Apr 21 2006, 02:22 PM) [snapback]367324[/snapback][/div][div class=\'quotemain\'][!--quotec--]
S o i must add this i n my query ?? ;)
[/quote]

Barand was as clear as he could be. MySQL Date columns have no Time component. If you need a Date + time in one column then you need to use a MySQL DateTime column. You can easily alter your table structure using ALTER TABLE to modify your DATE column to a DATETIME.

If you're still confused try reading this: [a href=\"http://www.gizmola.com/blog/archives/51-Exploring-Mysql-CURDATE-and-NOW.-The-same-but-different..html\" target=\"_blank\"]http://www.gizmola.com/blog/archives/51-Ex...different..html[/a]


Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.