[RESOLVED] Inconsistent timestamp values

[dmacman1962]

Hi everyone,

I am not sure why I am getting inconsistent values for my DateTime stamp.

$Datetime = date('m\-d\-Y g:s:i A');

I just did an insert and on my computer it was 2:11 PM EST (GMT-05:00) and my server was 2:10 PM EST (GMT-05:00) but the record was recorded as 12-19-2007 2:59:08 PM???

For this particular database, the DataTime field is a varchar with a length of 32, decimals 0, not null.

And in the past, I have seen sequential inserts with timestamps that were out of order (some where inserted first, but had later timestamps).

What am I missing?

Thanks in advance,

Don

[laserlight]

It looks like you mixed up your seconds and minutes. Instead of 'm-d-Y g:s:i A' it should be 'm-d-Y g:i:s A'.

[dmacman1962]

Duh!

Thanks, laserlight, so much for copy and paste.

I made the error a few forms ago, and never caught it.

I appreciate the help.

Thanks,
Don