Data in a Date field in SQL

[Anon]

Dear Readers,

What kind a data do I have to put in a date field, this question sounds stupid.. But I tried to put all kind of data in it and it always comes up with the warning this is not a valid date.. I heard something about a 'timestamp' or something.. Can somebody help me?

Greetings,

Kasper Schoonman (16yr)

[Anon]

put something like 20010822 in there... that is a valid date.

[mithril]

Kasper,

Assuming you're dealing with MySQL............

MySQL has 5 date/time field types: date, datetime, time, year, and timestamp. Their values are explained in the MySQL manual at:

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_types

A very useful function for record inserts is NOW(). This is a MySQL function which automatically calculates and returns the current system time in the format appropriate to the column's datatype. For example:

$sql = "INSERT INTO my_table (date_field) VALUES (NOW())";

Note the fact that the NOW() function does not need to be enclosed in quotes with the SQL query. HTH.

Geoff A. Virgo