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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-26 : 09:18:38
|
| Ayman writes "Hi there I'm trying to fetch a recors from the DB sql and I'm using a where condition,this condition is to retreive the records from the db where the current date is greatter than the date field in the dbalso the same logic condition for the time.but it is not retreive the proper records....will you help me PLZ.my code is:SELECT DISTINCT EmailFrom FROM Web_V_WFmain_and_V_Det_and_SubDet WHERE RIGHT(CONVERT(datetime, WF_DeadLineTime, 100), 6) <= RIGHT(CONVERT(datetime, GETDATE(), 100), 6) AND LEFT(CONVERT(datetime, WF_DeadLineDate), 11) <= LEFT(CONVERT(datetime, GETDATE()), 11) THANKSAYMAN JAMEEL AJA" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-26 : 09:29:14
|
| Check for Convert function in BOL, though you are using but you are not utilizing the style option. check for style option in convert and doaway with left and right functions.-------------------------------------------------------------- |
 |
|
|
|
|
|
date time Compare