display current date -1 in sybase -
i trying display previous day's date sybase using select query:
select dateadd(day,-1,convert(char(10), getdate(), 23))
this query displays 2015-06-18 00:00:00.0
i expect output 2015-06-18
.
how can that?
try select dateadd(day,-1,convert(date, getdate(), 365))
Comments
Post a Comment