Automatic date & time input????

[SOLID]

Hey All,
How do i get the phpMyAdmin to automatically insert a date in a field and the time in another when a DB entry is made????

Please Help

SOLID

[DoppyNL]

If you make a field of the type "timestamp" mysql will automaticly set that to "now()" when an insert or update query is run.

This field can hold the date and the time at the same time.

See http://www.mysql.com/doc/en/DATETIME.html for more details on datetime types.

Greetz Daan

[SOLID]

thanks DoppyNL,
thats cool, i noticed that you can put just the date is there a way of just putting the time too?

Cheers

[Jay]

If you make a field of the type "timestamp" mysql will automaticly set that to "now()" when an insert or update query is run.

This field can hold the date and the time at the same time.

I thought he made that quite clear ;)

[SOLID]

Sorry Guys.
i understand that, its just that the tutorial im learning from is using an access DB and they can do an auto insert date and time seperatly?. and ive already set up seperate coloums for date & time. ill try to modify the code to do it with the one timestamp coloum
thanks for you help

[SOLID]

1 more question? how can i split them up and use them in different places?
im using coldfusion5 :

[DoppyNL]

mysql returns a string with the date and time in it.
Convert that to a unix timestamp, you can use this PHP function for that:

Code: Select all

function mysql_to_php_time($mysql_date)
{
   //-- mktime order = hour,min,sec,month,day,year
   return(mktime(substr($mysql_date,11,2),substr($mysql_date,14,2),substr($mysql_date,17,2),substr($mysql_date, 5,2),substr($mysql_date, 8,2),substr($mysql_date, 0,4)));
}

after that you can use the function date or strftime to make the date/time look like you want.

Greetz Daan

[SOLID]

Thanks DoppyNL
ill give that a go
Cheers