converting to DATE format

[jessy]

hi ,
i have a problem in mysql query , im using a calendar to insert a given date into the DB and the column is stored as a DATE when i use the mysql "insert into" the date is not stored its found to be empty , i think some conversion is needed , i tried storing the field as a varchar, it worked for sure but messed up with some other form so i need it to be stored as DATE

any help is greatly appreciated

[TheServant]

Have a look here.

To be more specific, you need to look at: FROM_UNIXTIME() and UNIX_TIMESTAMP( ).

Edit:: I found this again! It's a great post on different ways to do what you want with pro's and con's.