getting last seven days records from sybase table

[RAJARP]

Hi,
I have to get records which are updated in last 30 days.
one is a teradata table where i have used the following query

Code: Select all

select * from TERADATA.TABLE1 where upd_date between date-7 and date

and this query is executing fine.

the second one is a sybase table where i tried the following query

Code: Select all

select * from SYBASE.TABLE1  where upd_date between current_date-7 and current_date

but this query is giving me the following error while am trying view data

[IBM(DataDirect OEM)][ODBC Sybase Wire Protocol driver][SQL Server]Invalid column name 'current_date'.

so what is the sybase equivalent of

Code: Select all

where upd_date between date-7 and date

.

ps: I have never worked on sybase
Thanks in advance.

Regards,
Raja R P

[vinothkumar]

Try with getDate(). I found it through google only.

[ray.wurlod]

You have to find out how the particular database expresses current date. For example, in Oracle it's SYSDATE (if I recall correctly!). Consult a Sybase SQL manual.

[chulett]

... or DBA. And yes, you recall correctly.

[RAJARP]

hi all,
I have got one query

select * from SYBASE.TABLE1 where upd_date >=dateadd(dd,-7,getdate()) and upd_date <=getdate()

but yet to check it. any idea that this query would work?

Regards,
Raja R P

[RAJARP]

HI,
the below query is working. I have checked it. Thanks to all for your inputs

Code: Select all

select * from SYBASE.TABLE1 where upd_date >=dateadd(dd,-7,getdate()) and  upd_date <=getdate()

Regards,
Raja R P