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

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

Kivy: Swiping (Carousel & ScreenManager) -