Date and Time

[Anon]

I've declared the date in my database as a (varchar) and I am getting the date value using the PHP function date().
Is this correct?
In other words, which is better, to declare the date in the database as a (date) or as a stirng (varchar).

Thx

[geo115fr]

The benefit to declare the field as date or datetime is that you can use the database builtin functions such as year(mydate), month(mydate), weekday(mydate). It is specially usefull in where clauses.

[jaddh]

But when I've declared the date field as "date", and after I have added some records, there was no date value in those records except the default values.
In other word, how can I use the "date" type in MySQL, and does "date" take its values automaticlly when you add a record, or what??

Thx