how to get Datediff SQL type
Moderators: chulett, rschirm, roy
how to get Datediff SQL type
Hi Experts.
i am doing timestamp diff between two colums i.e (2010-03-15 13:47:00 -2010-03-15 15:56:00 ) to get the differnce of Minutes.
(to_date - from_date) -> Mins_cals giving the out put SQL type as double , giving error "Invalid conversion requested from a dfloat to a timestamp."
what type do i need to define for the dirrerence value . (SQL type)
i am doing timestamp diff between two colums i.e (2010-03-15 13:47:00 -2010-03-15 15:56:00 ) to get the differnce of Minutes.
(to_date - from_date) -> Mins_cals giving the out put SQL type as double , giving error "Invalid conversion requested from a dfloat to a timestamp."
what type do i need to define for the dirrerence value . (SQL type)
Code: Select all
SecondsSinceFromTimestamp('2010-03-15 15:56:00','2010-03-15 13:47:00'
You are the creator of your destiny - Swami Vivekananda
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 5
- Joined: Tue Apr 20, 2010 9:27 pm
Of course, they "should" all kinds of things in the documentation that they aren't. However (and I should have quoted it so it was more obvious) I was specifically replying to the question of the output type. Which is documented.desmondcheah wrote:The document doesn't really give good example.. They should include proper example into the doc.
Just want people to actually check there and not just post here and wait for something you can answer for yourself in a minute of reading.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers