need took automate date

[sonny1974]

INDV_PREG"."EXPCT_DUE_DT">={ts '2007-05-04 00:00:00'}

i want to change it so i dont have to change it everday.

is there a functions like today or something so i can do a a filter on it

 

[mrdenny]

What database platform is this for (SQL Server, Oracle, MySQL, etc)?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sonny1974]

sorry sql server

is it GetDate()?

 

[mrdenny]

Yes it is. (I asked because the format of the WHERE clause that you posted looks awfly like Oracle.)

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com