[Resolved] Obtainig current Date and Time

GaryAC

Hi,

I am trying to obtain the current date and time in PHP, e.g.

17/12/03 12:26pm

This value is to be stored in a mySQL db, of an attribute type of 'timestamp'.

Couldanyone tell me the best way to obtain this, I have looked on php.net, and there seems to be many different ways, which would best be used here?

Thanks for any help

Reg

Gary

addie

http://yu.php.net/manual/en/function.date.php

Norman_Graham

Hi Gary

If you want to store the date and time in the DB, use the MySQL timestamp function, not the PHP time functions, otherwise you'll be creating the date and time twice. Try this:

http://www.mysql.com/doc/en/DATETIME.html

HTH

Norm

GaryAC

It states that the DATETIME function stores it as:

'YYYY-MM-DD HH:MM:SS'

Which is what I want.

But I am not sure how to put it in a query.

The query I am using is:

$query2 = "INSERT INTO custord (custid, ortime, numdvd, carriage, orvalue)" .
"VALUES ('$custid', 'DATETIME', '$NoDVD', '$Tx', '$Total')";

As you can see I am populating the table using PHP variables. But if i can just enter the data and time via this mySQL function then that would be fine. But I am not sure how to call this function within my PHP.

Thanks for your help, its much appreciated

Reg

Gary

tiburblium

timestamps all the way! mabey im just wierd but i find it easier to store every date as a timestamp and do the formatting on output rather then converting to and from timestamps whenever you have to do date math.

Just my .02 cent

GaryAC

Ok, but for some reason I can't find out how to obtain the current date and time using any of the time functions in PHP.

Have you any examples I could look at??

Thanks for your help

Reg

Gary

GaryAC

Figured it out. I am using now() in my insert statement. Which displays todays date and time. Perfect.

Thanks for the help.