469,930 Members | 1,722 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,930 developers. It's quick & easy.

help to retieve only the difference in minutes between two dates in DATETIME format

Jag
Hi all,
i am just lookin for a func or way about to retrieve the
difference in minutes between 2 dates which are of DATETIME data type
for induvidual records help in this regard is highly solicited
Thankz in Advance
Jag

Dec 18 '06 #1
4 10543

Jag wrote:
Hi all,
i am just lookin for a func or way about to retrieve the
difference in minutes between 2 dates which are of DATETIME data type
for induvidual records help in this regard is highly solicited
Thankz in Advance
Jag
see UNIX_TIMESTAMP(date)

Dec 18 '06 #2
Jag wrote:
Hi all,
i am just lookin for a func or way about to retrieve the
difference in minutes between 2 dates which are of DATETIME data type
for induvidual records help in this regard is highly solicited
Thankz in Advance
Jag
I would do something like this:

SELECT TIME_TO_SEC(TIMEDIFF('2006-11-23 23:45:00', '2006-11-30 23:46:31'));

which results in to 604709 seconds.

Jonathan
Dec 18 '06 #3
Jag
Thankz Jonathan your query was highly helpful,

Jonathan wrote:
Jag wrote:
Hi all,
i am just lookin for a func or way about to retrieve the
difference in minutes between 2 dates which are of DATETIME data type
for induvidual records help in this regard is highly solicited
Thankz in Advance
Jag

I would do something like this:

SELECT TIME_TO_SEC(TIMEDIFF('2006-11-23 23:45:00', '2006-11-30 23:46:31'));

which results in to 604709 seconds.

Jonathan
Dec 19 '06 #4
Jag
Thankz jonathan your query was highly helpful.
Thank u strawberry your sugesstion helped me in narrowing down the
search.
Jonathan wrote:
Jag wrote:
Hi all,
i am just lookin for a func or way about to retrieve the
difference in minutes between 2 dates which are of DATETIME data type
for induvidual records help in this regard is highly solicited
Thankz in Advance
Jag

I would do something like this:

SELECT TIME_TO_SEC(TIMEDIFF('2006-11-23 23:45:00', '2006-11-30 23:46:31'));

which results in to 604709 seconds.

Jonathan
Dec 19 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Thomas W | last post: by
5 posts views Thread by Larry Bird | last post: by
4 posts views Thread by Mohan | last post: by
5 posts views Thread by settyv | last post: by
5 posts views Thread by soni2926 | last post: by
1 post views Thread by bbawa1 | last post: by
3 posts views Thread by RN1 | last post: by
15 posts views Thread by student4lifer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.