[Resolved] MySQL Datetime Question

[magic-chef]

This is the mysql datetime:

2003-07-02 12:00:00

Is this 12 noon or 12 midnight and what is the correct representation of each?

I need to have the entry be 12 midnight

[Pig]

Use a unix timestamp instead. It eliminates any confusion and is FAR more versatile. You can always use date() to get a formatted date out of it.

[magic-chef]

Suppose I used:

$currentdt=date('U');
$startdt=mktime(0, 0, 0, date("n", $currentdt), date("j", $currentdt), date("Y", $currentdt));

I assume it will give the date as midnight on the current day.

[kevinsequeira]

12:00:00 is in the afternoon, 24:00:00 or 00:00:00 is midnight

reg
kevin

[magic-chef]

Is my assumption correct in my previous post?

$currentdt=date('U');
$startdt=mktime(0, 0, 0, date("n", $currentdt), date("j", $currentdt), date("Y", $currentdt));

yields midnight?

[magic-chef]

Ok,

code:
$currentdt=date('U');
$startdt=mktime(0, 0, 0, date("n", $currentdt), date("j", $currentdt), date("Y", $currentdt));

the output to the above two lines is:

2003-07-02 10:31:15=curdt
2003-07-02 12:00:00=strtdt

Why does the mktime with 3 leading zeros lead to 12:00:00 (noon) instead of 00:00:00 (midnight)?

[kevinsequeira]

EDIT : just do this

$currentdt=date("Y-m-d")." 00:00:00";
echo $currentdt."<BR>";

reg
kevin

[magic-chef]

I took Kevin'd advice:

$currentdt=date("Y-m-d")." 00:00:00";
$startdt=mktime(0, 0, 0, date("n", $currentdt), date("j", $currentdt), date("Y", $currentdt));
$ucurdt=strtotime($currentdt);
echo $currentdt."=curdt<br>";
echo $ucurdt."=Unix curr<br>";
echo date("Y-m-d g:i:s", $ucurdt)."=Unix reformat<br>";
echo date("Y-m-d g:i:s", $startdt)."=strtdt<br>";

output:

2003-07-02 00:00:00=curdt
1057118400=Unix curr
2003-07-02 12:00:00=Unix reformat
1969-12-31 6:59:59=strtdt

Why does this always go back to noon(note Unix reformat)?

[magic-chef]

I'm still looking for a answer to my previous post. Does anyone know why this occurs? See the immediate prior post.