SQL Server 2008:
SELECT cast(AttDate as time) [time]
FROM yourtable
Earlier versions:
SELECT convert(char(5), AttDate, 108) [time]
FROM yourtable
Microsoft Learn
learn.microsoft.com › en-us › sql › t-sql › functions › cast-and-convert-transact-sql
CAST and CONVERT (Transact-SQL) - SQL Server | Microsoft Learn
Other values are processed as 0. Beginning with SQL Server 2012 (11.x), the only styles supported, when converting from date and time types to datetimeoffset, are 0 or 1.
Videos
09:05
Learn SQL: Converting non-date fields to Date/Time format - YouTube
12:15
Converting a String to Date in SQL | CAST | CONVERT | TRY_CAST ...
09:05
SQL | How to Convert Date / Time Formats ? | Convert | Format - ...
00:44
Easiest Way Convert Date Time in AM PM Format SQL Server - YouTube
GeeksforGeeks
geeksforgeeks.org › sql › sql-query-to-convert-datetime-to-date
SQL Query to Convert DateTime to Date in SQL Server - GeeksforGeeks
Here are four common and effective methods to convert DateTime to Date in SQL Server: The CAST() function in SQL Server is one of the most flexible functions available. It allows you to explicitly convert one data type to another, and it's perfect ...
Published July 23, 2025
W3Schools
w3schools.com › sql › func_sqlserver_convert.asp
SQL Server CONVERT() Function
String Functions: Asc Chr Concat with & CurDir Format InStr InstrRev LCase Left Len LTrim Mid Replace Right RTrim Space Split Str StrComp StrConv StrReverse Trim UCase Numeric Functions: Abs Atn Avg Cos Count Exp Fix Format Int Max Min Randomize Rnd Round Sgn Sqr Sum Val Date Functions: Date DateAdd DateDiff DatePart DateSerial DateValue Day Format Hour Minute Month MonthName Now Second Time TimeSerial TimeValue Weekday WeekdayName Year Other Functions: CurrentUser Environ IsDate IsNull IsNumeric SQL Quick Ref · SQL Examples SQL Editor SQL Quiz SQL Exercises SQL Server SQL Syllabus SQL Study
MSSQLTips
mssqltips.com › home › sql date format examples using convert function
SQL Date Format Examples using SQL CONVERT Function
September 26, 2025 - SQL Server provides a number of date and time formatting options and in this article we look at how to use SQL CONVERT to output different date/time formats such as mm/dd/yy, mm/dd/yyyy, dd-mm-yyyy, etc.
SQL Easy
sql-easy.com › learn › how-to-convert-datetime-to-date-in-sql-server
How to Convert DATETIME to DATE in SQL Server Effortlessly - SQL Knowledge Center
February 9, 2024 - Here are the common ways I’ve found effective: SELECT CAST(datetime_column AS DATE) FROM table_name; This method is straightforward and widely supported across different SQL databases.
Database Guide
database.guide › convert-datetime-to-time-in-sql-server-t-sql-examples
Convert 'datetime' to 'time' in SQL Server (T-SQL Examples)
+-------------------------+----------+ | datetime | time | |-------------------------+----------| | 2025-05-21 10:15:30.527 | 10:15:31 | +-------------------------+----------+ Here’s an example of an explicit conversion. In this case, I use the CAST() function directly within the SELECT statement ...
DB Vis
dbvis.com › thetable › extracting-time-and-date-in-ms-sql-server-a-comprehensive-guide
Extract Date and Time in MS SQL Server: A Complete Guide
February 7, 2025 - CAST is a straightforward function that changes one data type to another (e.g., datetime to date). CONVERT adds the ability to specify styles, which give you control over the format of the output string (e.g., yyyy-mm-dd, hh:mm:ss).If you only ...
Microsoft Learn
learn.microsoft.com › en-us › sql › t-sql › data-types › datetime-transact-sql
datetime (Transact-SQL) - SQL Server | Microsoft Learn
UNION SELECT '01/01/2024 23:59:59.990', CAST('01/01/2024 23:59:59.990' AS DATETIME); Here's the result set. ... When you convert to date and time data types, the Database Engine rejects all values it can't recognize as dates or ...
DotFactory
dofactory.com › sql › convert-datetime-to-date
SQL Convert DATETIME to DATE
CONVERT converts the datetime value to a date format. A datetime includes both date and time whereas date only includes the date.
Database Star
databasestar.com › convert-datetime-to-date
How to Convert DATETIME to DATE in SQL Server | Database Star: Home
July 2, 2020 - The syntax for this is CONVERT (datetime, format). For example, to convert the current date and time into just a date: ... This shows the date only and no time. ... There are different ways you can use CAST, DATEDIFF, FLOOR, and CONVERT to get ...
SQLServerCentral
sqlservercentral.com › articles › combine-date-and-time-to-datetime2-in-sql-server
Combine DATE and TIME to DATETIME2 in SQL Server – SQLServerCentral
July 27, 2023 - DECLARE @OriginalDT DATETIME2 = '2023-12-31 23:59:59.9995000'; SELECT RoundedUp = CONVERT(DATETIME,DATETRUNC(ms,@OriginalDT)); ... Like I said, we'll cover how to combine DATE and TIME datatype columns to DATETIME in a separate article.
Reddit
reddit.com › r/sql › how to convert to a specific date/time format?
r/SQL on Reddit: How to convert to a specific date/time format?
October 8, 2020 -
I'm currently using the query below to convert eastern time to UTC:
Convert(datetime,CreationTime, AT TIME ZONE 'Easterm Standard Time' AT TIME ZONE 'UTC')
How can I use this query and convert it to the time format below?
YYYYMMDD-HH:MM:SS.000
Top answer 1 of 3
4
Pseudo code Declare @DateTime = Your code Convert (varchar, @DateTime, 112) + '-' + convert (varchar, @DateTime, 114) Should do it. Honestly though I'd just leave that kind of work to your presentation layer.
2 of 3
1
FORMAT() is the easiest solution. You can format a date anyway you want. Microsofts article is comprehensive enough I reckon. https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql?view=sql-server-ver15
SQL Server Tutorial
sqlservertutorial.net › home › sql server system functions › convert datetime to date
Convert Datetime to Date in SQL Server By Practical Examples
April 11, 2020 - The following example uses the CONVERT() function to convert a datetime to a date: SELECT CONVERT(DATE, GETDATE()) date; Code language: SQL (Structured Query Language) (sql)
Reddit
reddit.com › r/sqlserver › how i can convert from datetime to total hours?
r/SQLServer on Reddit: How i can convert from datetime to total hours?
April 4, 2021 -
I do this query and the result is a datetime, i try so much variants, but nothing work it... I want the result to be displayed in the number of total hours, like (in this case): 25:01:05 because i have 2 days en this datetime, I have had results like 01:01:05 which is when it only subtracts the hours from the datetime. I would like that as well as add the hours by the number of days, do it with the months if it can be
Top answer 1 of 5
6
Does SUM(DATEDIFF(MINUTE, 0, calcHsTrabajadas))/60.0suffice? You can be more granular with SECOND if you need to, just divide by 3600.0 instead. As others have said SQL Server’s time types expect a time of day not an interval of time, so you’ll need to format this into hh:mm:ss separately. Ideally outside of SQL Server, because an RDBMS shouldn’t have to deal with presentation concerns.
2 of 5
1
There is no native data type in SQL server that can represent time in that way. All the types, datetimeoffset included, can't exceed in their time part the value of 23:59:59(.99999999). You can, instead, represent the total hours with a decimal value, with due problems of fraction calculation. I think that, depending on your requirements, the best compromise could be to build up an integer in the fashion of an iso date, that's to say something like 250340 (standing for 25 hours, 3 minutes and 40 seconds).
C# Corner
c-sharpcorner.com › article › convert-datetime-to-different-formats-in-sql-server
Mastering the Art of Convert DateTime Formats In SQL Server with Over 30 Code Examples
October 4, 2023 - Here we will use the "CONVERT" function to convert a datetime into a different format in SQL Server. By using some built-in function in SQL Server, we can get the datetime value in a specific format.
SQLServerCentral
sqlservercentral.com › forums › topic › convert-datetime-to-just-time-only-hour
Convert datetime to just time (only hour) – SQLServerCentral Forums
September 26, 2008 - I have one datetime column named Hours in SQL Server Table1, which gives the output as 09/26/2008 01:00:00, 09/26/2008 02:00:00, 09/26/2008 03:00:00 till 09/26/2008 12:00:00 format. I wanted to get just the year in int datatype from this format and I got it using (SELECT CONVERT(int, YEAR (Hours)) AS Year FROM Table1) and I am getting the correct Year as I wanted 2008.
Top answer 1 of 4
8
Tysss I have made a demo for you please try this, Here I have used GETDATE() for return current date with a timestamp where you have to pass your column name as you showed in the question which is TimeStamp.
SOLUTION 1
SELECT CAST(CONVERT(VARCHAR,GETDATE(),110) AS DATE) AS DATE
OUTPUT
2019-05-17
SOLUTION 2
SELECT CAST(CONVERT(VARCHAR,GETDATE(),110) AS DATETIME) AS DATE
OUTPUT
2019-05-17 00:00:00.000
I think you need the only date from TimeStamp so, you need to change the datatype DATE else if you will keep your datatype DATETIME then it will return date something like 2019-05-17 00:00:00.000
2 of 4
1
select GETDATE() as TimeStamp,
convert(date, getdate()) as date
Top answer 1 of 12
22
For SQL Server 2005 and below:
CopyCONVERT(varchar(8), @ParamDate, 112) -- Supported way
CAST(FLOOR(CAST(@ParamDate AS float)) AS DATETIME) -- Unsupported way
For SQL Server 2008 and above:
CopyCAST(@ParamDate AS DATE)
For SQL Server 2022 and above:
CopyDATETRUNC(d, @ParamDate)
2 of 12
14
Copydeclare @originalDate datetime
select @originalDate = '2009-06-24 09:52:43.000'
declare @withoutTime datetime
select @withoutTime = dateadd(d, datediff(d, 0, @originalDate), 0)
select @withoutTime
SQLines
sqlines.com › sql-server-to-mysql › functions › convert_datetime
SQL Server CONVERT for Datetime in MySQL - SQLines Tools
In SQL Server, you can use CONVERT function to convert a string with the specified format to a DATETIME value. In MySQL, you can use STR_TO_DATE function if you need a specific format, or CONVERT if you need the default format. Note that the order of parameters in SQL Server and MySQL CONVERT ...