Sep 22, 2008 · @user1671639 the datetime data type always contains both a date and a time, you can't sensibly store one without the other - unless you're using SQL Server 2008, in which case there are also separate 'date' and 'time' data types.

Jun 18, 2012 · You will want to use the YYYYMMDD for unambiguous date determination in SQL Server. insert into table1(approvaldate)values('20120618 10:34:09 AM'); If you are married to the dd-mm-yy hh:mm:ss xm format, you will need to use CONVERT with the specific style. insert into table1 (approvaldate) values (convert(datetime,'18-06-12 10:34:09 PM',5));

May 24, 2014 · See the Date and Time Styles section of CAST and CONVERT (Transact-SQL) for all of the built-in formatting styles. I would keep in mind that unless you have a good reason for it, I mean a really good reason, formatting is usually a better job …

Feb 9, 2011 · For anyone not following, 0 represents the min date 1900-01-01.So this gets the (negative) number of days between the column value and 0, then adds those negative days to the column value which "zeros out" the date portion to 1900-01-01 and you're left with only the time.

Aug 5, 2009 · 1. Is there a function available in SQL? Yes, the SQL 92 spec, Oct 97, pg. 171, section 6.16 specifies this functions: CURRENT_TIME Time of day at moment of evaluation CURRENT_DATE Date at moment of evaluation CURRENT_TIMESTAMP Date & Time at moment of evaluation 2.

DECLARE @Date date = SYSDATETIME(); DECLARE @Time time(0) = SYSDATETIME(); SELECT CAST(CONCAT(@Date, ' ', @Time) AS datetime2(0)); This would also work given a table with a specific date and a specific time field. I use this method frequently given that we have vendor data that uses date and time in two separate fields.

Jul 3, 2013 · The following is simple and works on SQL Server 2008 (SP3) and up: PRINT @@VERSION PRINT GETDATE() PRINT GETDATE() + '01:00:00' PRINT CONVERT(datetime,FLOOR(CONVERT(float,GETDATE()))) + '01:00:00' With output: Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Mar 15 …

Jun 22, 2013 · I want to split this into two columns: Date: 2013-06-22. Time (Remove Microseconds): 13:36:44. Can anyone modify my existing query to display the required output? That would be greatly appreciated. Please Note: I'm using SQL Server Management Studio 2008.

Jul 24, 2009 · For SQL Server 2008+, you can CAST to date i.e. CAST(getdate() AS date). Or just use date datatype so no time to remove. Edit, Jan 2012. A worked example of how flexible this is: Need to calculate by rounded time or date figure in sql server. Edit, May 2012

Dec 20, 2008 · You can either use any of the recommend range queries mentioned, or in SQL Server 2008, you could use the DATE only date time - or you could do a check something like: select * from tblErrorLog where DAY(errorDate) = 20 AND MONTH(errorDate) = 12 AND YEAR(errorDate) = 2008