Time Difference
Posted: Sun Aug 08, 2004 1:56 pm
I wanted to find out the no: of days elapsed since it was entered
select DATE_FORMAT(now()-20040807111937,"%D")
returns NULL.
I know DATE_SUB can be used but I was just wondering why this is returning null when now()-20040807111937 is returning a no:
Any Ideas ?
Thanks
select DATE_FORMAT(now()-20040807111937,"%D")
returns NULL.
I know DATE_SUB can be used but I was just wondering why this is returning null when now()-20040807111937 is returning a no:
Any Ideas ?
Thanks