Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

compare timepart of datetime field in SQL

2 Posts 2 Posters 0 Views 1 Watching

A Offline
A Offline
asdf1753

wrote on last edited by

#1

hi how can i compare timepart of datetime field in SQL, from example: time part of datetime field between '18:25:36'and '22:10:13' thank you :rose:
B 1 Reply Last reply

0
A asdf1753

hi how can i compare timepart of datetime field in SQL, from example: time part of datetime field between '18:25:36'and '22:10:13' thank you :rose:
B Offline
B Offline
Bill Dean

wrote on last edited by

#2

Have you tried DATEDIFF? Take a look in the BOL. You might need to write a complicated where to make it work, but it should be able to do the trick for you. Bill
1 Reply Last reply

0

Log in to reply