DateDiff returns in HH:MM format
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Hi - Is there a way we could return the result in above format - know of hours, minutes, seconds. Thanks for your time. Vani
VK-Cadec wrote:
Is there a way we could return the result in above format - know of hours, minutes, seconds.
DateDiff returns the result in an internal format. It is merely the rendering of that data on the screen that gives it a format. The formatting of data should be the function of your application's presentation layer, not the database.
Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos