Mysq date type

[feri_soft]

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 ?

[Barand]

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]

[448191]

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.

[Barand]

I was born in Jan, 1949. Try storing my dob in a unix timestamp.

[feri_soft]

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

[gizmola]

[!--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]