Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Flag the last two hours of the day

Author  Topic 

MichelleMabbs
Starting Member

24 Posts

Posted - 2014-02-04 : 05:00:49
Hi i have an hours and a seperate minutes column

e.g.

Hour
10
Minute
15

I now need to flag the last two hours of the day in a new colum

both datatypes are INT

Be great if i could get some help with this

Michelle

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2014-02-04 : 05:51:30
duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=191086

please do not cross post


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

MichelleMabbs
Starting Member

24 Posts

Posted - 2014-02-04 : 06:23:44
sorry i didnt realise i posted in the wrong forum thank you

Michelle
Go to Top of Page
   

- Advertisement -