How can I convert date and time using ODBC function?

Question

Question:

I need to get ONLY DATE (= date WITHOUT time) using ODBC escape sequence .

However

SELECT 
     {fn CONVERT(SomeTable.Col_With_DateTime_Value, SQL_DATE)}
FROM SomeTable

returns the column as a date WITH time value.

Is there an ODBC function that I can use to get the date only?

Note:
This is not a duplicate question.

I know it is possible to use the non- ODBC convert function like

CONVERT(char(8),  getdate(), 112) AS v112_ISO  
CONVERT(char(10), getdate(), 104) AS v104_XML

but I really need an ODBC function for compatibility.

+3

Stefan steiger 29 Mar 12 at 9:24 am

2 answers

select cast(day(getdate()) as varchar(2))+'/'+cast(month(getdate()) as varchar(2))+'/'+cast(year(getdate()) as varchar(4))

or

SELECT CONVERT(VARCHAR(10),GETDATE(),111)

-2

Diego 29 Mar 12 at 10:03

Mikael Eriksson · Accepted Answer · 2012-03-29T10:03:48+0000

You can use this:

select {fn convert({fn timestampdiff(SQL_TSI_DAY, 0, DatetimeCol)}, SQL_DATE)}
from SomeTable

Works in environments I have for testing (SQL Server 2000-2012).

Update:

Here's another way that I think might be faster than using convert.

select {fn timestampadd(SQL_TSI_DAY, {fn timestampdiff(SQL_TSI_DAY, 0, DatetimeCol)}, 0)} 
from SomeTable