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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Date functions

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-24 : 08:50:10
Cesar Henao writes "I would like to query a table where I have a column name date, I would like to know what was inputted yesterday. On access 2000 I used to use Date() - 1. Someone recommended GetDate() - 1 and that didn't work.

Can anyone please help.

Cesar Henao"
   

- Advertisement -