Sybase How to get dash separated date yyyy-mm-dd?

datetime sybase sap-ase
zdd picture zdd · Apr 11, 2014 · Viewed 10.1k times · Source

I want to get date in such format yyyy-mm-dd, for example 2014-04-11. But it seems there is no way to do this in Sybase (ASE 12.5) with the convert function.

Currently, I get the date by 112 and add the - between digits. Any good way?

Answer

Paul picture Paul · Aug 25, 2015

Take advantage of format 140: yyyy-mm-dd hh:mm:ss.ssssss

Use char(10) to make Sybase truncate the string to just the first 10 characters, i.e.

convert(char(10), col1, 140)

Related questions

Sybase: How to get the current date in mm/dd/yyyy format?

I want to insert the mm/dd/yyyy format into a table and after that compare it with the current date when fetching results from the table to display. The getdate() function returns the complete timestamp and am unable to …

Read More
How to get the current time in Python

What is the module/method used to get the current time?

Read More
Converting string into datetime

I've got a huge list of date-times like this as strings: Jun 1 2005 1:33PM Aug 28 1999 12:00AM I'm going to be shoving these back into proper datetime fields in a database so I need to magic them into real datetime objects. This …

Read More