22 сент. 2008 г. · SQLServer 2008 now has a 'date' data type which contains only a date with no time component. Anyone using SQLServer 2008 and beyond can do the following:

10 окт. 2011 г. · The simplest way to get the time from datetime without millisecond stack is: SELECT convert(time(0),getDate())

21 окт. 2022 г. · I have a report to do, so I need to return a date from a datetime column, but it need to come only with the date from the column.

3 февр. 2014 г. · Simply cast your timestamp AS DATE, like this: SELECT CAST(tstamp AS DATE) SQLFiddle Demo In other words, your statement would look like this:

4 сент. 2016 г. · SQL Server Compact has no date type. If you don't want to see the time, convert the datetime value to a string: SELECT CONVERT(nvarchar(10), GETDATE(), 120)

16 апр. 2015 г. · You can use CAST(column_name AS DATE) for Sql-server 2008 and above version. SELECT [name], [book_id], [book_name], cast([taken_date] as date) as [taken_date].

1 авг. 2013 г. · Currently sql returns the date as 2013-07-01 00:00:00.000. I want only the date part in mm/dd/yyyy format so that when I export it to excel I can still sort.

26 мая 2011 г. · I want to extract just the date part from a timestamp in PostgreSQL. I need it to be a postgresql DATE type so I can insert it into another table that expects ...

19 июл. 2010 г. · How do you extract just date from datetime in T-Sql? 2 · How to get only the date from DateTime information in sqlserver? 0 · how to trim Date ...

18 нояб. 2009 г. · You can use MySQL's DATE() function: WHERE DATE(datetime) = '2009-10-20'. You could also try this: WHERE datetime LIKE '2009-10-20%'.