Getdate(), -1 day

sql sybase sqlanywhere
N2hvits picture N2hvits · Jan 12, 2016 · Viewed 74k times · Source

I do not understand why, but somehow this query doesn't work. I want to take system date -1 day where the sysdate is smaller by 1 day then current date.

WHERE
    a.SEND_Date >= dateadd(DD,-1,(CAST(getdate() as date) as datetime))

Answer

Yahel picture Yahel · Jan 12, 2016

The CAST depends on what kind of date type you need. If you need only to compare dates you can use only:

dateadd(DD, -1, cast(getdate() as date))

If you need to compare with date time you can use:

dateadd(DD,-1,getdate())

That wil give you datetime like this: 2016-01-11 10:43:57.443

Related questions

How to delete duplicate rows in sybase, when you have no unique key?

Yes, you can find similar questions numerous times, but: the most elegant solutions posted here, work for SQL Server, but not for Sybase (in my case Sybase Anywhere 11). I have even found some Sybase-related questions marked as duplicates for SQL …

Read More
How to list all the user tables in SQL Anywhere along with their rowcount?

I'd like to list all available tables in my DB, and be able to sort and filter by row count.

Read More
Convert INT to VARCHAR SQL

I am using Sybase and I am doing a select which returns me a column called "iftype", but its type is int and I need to convert into varchar. When I try to do the select without the convert function …

Read More