[Resolved] datetime & TimeStamp

[vinny199]

The following code was working fine with : WHERE (TO_DAYS(eve_sortdate) -TO_DAYS(NOW()) < 100) to display events only past todays date.

I had an eve_sortdate with a TimeStamp that would print in the database dates like: 20040414121452

I'm trying to do the same thing for another website, but unfortunatly, the eve_sortdate (equivalent of it on that site) has been set as a "datetime" instead of "timeStamp" (and changing it would affect other areas of the site, so not possible)

and the printed date formating is different:

2003-07-26 10:02:00

My code is not having any effect on this.

could you help showing me an equivalent of WHERE (TO_DAYS(eve_sortdate) -TO_DAYS(NOW()) < 100) but for an eve_sortdate with a datetime formating?

Basically, i need to show past events only from todays date.
Thanks,

Vinny

[czambran]

you could use the mysql fumction UNIX_TIMESTAMP() to convert the data to a timestamp and keep the same code.

[vinny199]

Thanks,

that sounds just great.
but how exactly would I use UNIX_TIMESTAMP() ?

is it something to add to my recordset?

[czambran]

You would use it on the select statement.
Something like this:
WHERE (TO_DAYS(UNIX_TIMESTAMP(eve_sortdate)) -TO_DAYS(NOW()) < 100)

Assuming eve_sortdate is a date field instead of a timestamp field

[vinny199]

Thanks a lot.

that solves it

vinny