date() and mktime() problem

[Anon]

Hello, I am inserting a date into a mysql dbase and for some reason it doesn't show the "hour", "minute" ,and "seconds" .. All I get is 00:00:00 for the time.. Here is my string:

$endDate = date("Ymd H:i:s",mktime(0,0,0,$emonth,$eday,$eyear));

this returns the following:
2001-03-23
00:00:00

why is it returning 00:00:00 ???
What the heck am I doing wrong? Im running php 4 (not sure if that matters)..

Any help is appreciated.

[Anon]

Greg,

The "0, 0, 0," in your mktime() function is where the time is coming from.

You are setting hours=0, minutes=0 and seconds=0.

If you want a specific time, you should enter it, instead of the 0s.

[Anon]

Thanks David.. How would I get the "current time" .. would i just use the time() function? like so:

$endDate = date("Ymd H:i:s",mktime(time(),$emonth,$eday,$eyear));

or would this be formated wrong? I need it formated in the Hour:Minute:seconds format.

or am i completely wrong?

[Anon]

Greg,

I would use the following code:

$endDate = date("Ymd H:i:s",mktime(date(H),date(i),date(s),$emonth,$eday,$eyear));

I hope this works for you

[Anon]

David.. You are the man!! Thanks for your quick response and help. It worked perfectly.

[nielst]

Even simpler, if you just leave out the second argument to date(), it will fill in the current time and date.

E.g. $endDate = date("Ymd H:i:s");

Niels