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 |
|
baska123
Yak Posting Veteran
64 Posts |
 Posted - 2007-08-07 : 12:37:49
|
| How do I read system date? |
|
|
baska123
Yak Posting Veteran
64 Posts |
Posted - 2007-08-07 : 12:40:23
|
| Actually I want to see if there is todays date in a column called ADJ_TRANS_DATE. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-07 : 12:53:15
|
| Use getdate(). |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-08 : 01:47:46
|
| Where ADJ_TRANS_DATE>=Dateadd(day,Datediff(day,0,Getdate()),0)MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
System date