SQL Server Performance Forum – Threads Archive

datetime script

Is there any way to get the current date time while running a script. I want to runn a script like: select * from table where DateTimeLastTrans > [current date/time – 30 min] Thanks for any help,
Ben

---

Kindly don’t duplicate post.
You allready have ansewrs from Chakry in other forum. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

---

]]>