Question about date / datetime fields

ade234uk

1) When I insert a date in to the date field of MySql I use the following code

$date1 = date("Y-m-d")

I then INSERT this in to the database

I have seen a field type called datetime, now I presume this will allow me to insert the the date and the time.

Using my exisiting code $date = date("Y-m-d") how would I create the time?

2) Secondly how do I insert dates in UK date format d-m-Y instead of US format which is currently Y-m-d

3) I have worked out how to get two dates from the database, convert these to strings using the strtotime command which is great, becuase I can compare the two values.

Can I still use strtotime when grabbing the date and the time from the type datetime using the following code

echo $date1 = strtotime($row['$date1']);

Installer

1) $date = date('Y-m-d H:i:s');

2) What is generally called "US format" is m/d/Y, not Y-m-d. If you enter a date in d-m-Y format into a date or datetime field, MySQL will choke.

3) Yes.

The DATETIME, DATE, and TIMESTAMP Types

ade234uk

Thank you for your help. Thats great. I will worry about UK format another day.

Installer

Glad to help.

I missed something earlier, though. Your example code: echo $date1 = strtotime($row['$date1']); won't work. Because of the single quotes $date1 will be interpreted literally. Leave the quotes out.