Usage of date_sub command

[Guest_imported]

Hi All,

I'm trying to substract one date in my database from another date. I know that you can do it in this type of format(mysql> SELECT DATE_SUB("1998-01-01 00:00:00",
INTERVAL "1 10" DAY_HOUR). I got that from the mysql manual. My problem is that the values are not hardcoded in the coding but dynamically obtain from the database. I can't seem to get the right syntax for it to work.

Any suugestions/advice would be appreciated.

Star

 

[devnull22]

are you saying you can't get the correct format when the date is optained from the database ? if so , try this.

mysql> SELECT
DATE_SUB(DATE_FORMAT(date_field,'what ever format'),
INTERVAL '1 10' DAY_HOUR)
FROM blaa ;

hope this helps devnull22

http://www.photoflux.com

http://www.clickEval.com

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !