Posted on 2006-06-27
I wanna know the difference between two time variables:
1. char type as fetch from the datetime field from a table as follows:
select top 1 CONVERT(CHAR(5), myTime, 114) as newTime from table1
ex:10:30 (10 hour 30 min am)
2. time from system date as follows:
system.now.hour = 11
system.now.minutes = 40
giventime - currenttime
ex: 10.30 - 11.40
note: difference in minutes
I want to know the different between these two variables.
Anyone who can suggest very simple code for this solution?