Working with CURRENT

Working with CURRENT_TIMESTAMP

El Forum
Unregistered

#12

09-12-2012, 04:30 PM

[eluser]codemonkey[/eluser]

Quote:I’m guessing that you don’t actually have a date in your database that is between those particular dates (2012-08-29 AND 2012-09-05) in the date_created field. Have you verified that you do?

Yep I did and do.

I'll try formatting it like you show.

Quote:OP, can you determine that date field in your database is a DATETIME field and not a VARCHAR field.

The data type is timestamp, default is CURRENT_TIMESTAMP

Messages In This Thread

Working with CURRENT_TIMESTAMP - by El Forum - 09-11-2012, 10:14 AM

Working with CURRENT_TIMESTAMP - by El Forum - 09-11-2012, 11:55 AM

Working with CURRENT_TIMESTAMP - by El Forum - 09-12-2012, 01:15 PM

Working with CURRENT_TIMESTAMP - by El Forum - 09-12-2012, 01:31 PM

Working with CURRENT_TIMESTAMP - by El Forum - 09-12-2012, 01:59 PM

Working with CURRENT_TIMESTAMP - by El Forum - 09-12-2012, 02:02 PM

Working with CURRENT_TIMESTAMP - by El Forum - 09-12-2012, 02:08 PM

Working with CURRENT_TIMESTAMP - by El Forum - 09-12-2012, 02:09 PM

Working with CURRENT_TIMESTAMP - by El Forum - 09-12-2012, 02:12 PM

Working with CURRENT_TIMESTAMP - by El Forum - 09-12-2012, 02:18 PM

Working with CURRENT_TIMESTAMP - by El Forum - 09-12-2012, 04:24 PM

Working with CURRENT_TIMESTAMP - by El Forum - 09-12-2012, 04:30 PM

Working with CURRENT_TIMESTAMP - by El Forum - 09-12-2012, 05:34 PM

Working with CURRENT_TIMESTAMP - by El Forum - 09-13-2012, 03:58 AM

Working with CURRENT_TIMESTAMP - by El Forum - 09-13-2012, 06:00 AM