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 - 2001-11-07 : 09:04:37
|
| Salim writes "Hi,I am using sql server 2000 and i have a problemI am not able to get the yyyymmdd part from a field which is having data type datetime.I have a record ahving an entry 11/1/2001i tried to acces it by select * from customer where purchase_date = getdate()-1 getdate()-1 returns me yesterday's date and time but in database this perticular entry is 20001-11-01 00:00:00so it returns me 0 records please tell me how to extract yyyymmdd part from dattime fieldPlease reply me soonThank you" |
|
|
|
|
|
getting problem in date