Welcome Guest, Not a member yet? Register   Sign In
MySQL Timezone/Date Question?
#2

[eluser]danmontgomery[/eluser]
CURRENT_DATE returns the current date with no time, so it's assumed 00:00:00 of today, so subtracting 24 hours from that would give you anything since 00:00:00 yesterday... I believe what you want is NOW() instead of CURRENT_DATE, which includes the time.

Also, to check what current_date is returning:

Code:
SELECT CURRENT_DATE;


Messages In This Thread
MySQL Timezone/Date Question? - by El Forum - 03-17-2010, 02:46 PM
MySQL Timezone/Date Question? - by El Forum - 03-17-2010, 03:11 PM
MySQL Timezone/Date Question? - by El Forum - 03-18-2010, 04:06 AM



Theme © iAndrew 2016 - Forum software by © MyBB