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

sql datetime sybase
swateek picture swateek · Sep 28, 2013 · Viewed 25.3k times · Source

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 extract the date in my desired format.

Answer

Rahul Tripathi picture Rahul Tripathi · Sep 28, 2013

You are looking for this SQL to make the conversion:

select convert(varchar, date_column, 101) from the_table

The important part in part in this case is 101 which is specification of mm/dd/yyyy format as per documentation. If you have Sybase ASE 15.7 use this, if you have SAP ASE 16.0 (released 2014) use this (has more options).

Related questions

How to return only the Date from a SQL Server DateTime datatype

SELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part without the time part: 2008-09-22 00:00:00.000 How can I get that?

Read More
SQL query to select dates between two dates

I have a start_date and end_date. I want to get the list of dates in between these two dates. Can anyone help me pointing the mistake in my query. select Date,TotalAllowance from Calculation where EmployeeId=1 and Date …

Read More
How to convert DateTime to VarChar

I am working on a query in Sql Server 2005 where I need to convert a value in DateTime variable into a varchar variable in yyyy-mm-dd format (without time part). How do I do that?

Read More