Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to truncate seconds in TSQL?

Tags:

datetime

tsql

I have time, select cast(SYSDATETIME() AS time) 14:59:09.2834595

What is the way to truncate seconds? 14:59

like image 392
ob213 Avatar asked Jan 06 '12 21:01

ob213

1 Answers

Description

You can use the T-SQL function convert.

Sample

PRINT convert(varchar(5), SYSDATETIME(), 108)

will give you hh:mm

More Information

  • MSDN - CAST and CONVERT
like image 120
dknaack Avatar answered Sep 29 '22 13:09

dknaack
Sign in to Comment

Related questions

Stored Procedure to Insert Data from one table to another with same column names
How to prevent sqlcmd truncation with for xml path query result
Calling a SOAP webservice from TSQL stored procedure
SQL Server, nvarchar(MAX) or ntext, image or varbinary?
How can one iterate over stored procedure results from within another stored procedure....without cursors?
generate structured (xml) document from hierarchical table data (T-SQL)
Using 'LIKE' with an 'IN' clause full of strings
What is imprecise column in SQL Server?
How I can get the first 3 digits in 123456 Numbers in sql?
Indexing views with a CTE
SQL Distinct comma delimited list
OPENJSON cross apply with NULL values (TSQL)
Best way to check whether a row has been updated in SQL
SQL query to return one single record for each unique value in a column
T-sql: how to perform optimised Paging?
How to create a table type in Sql Server 2005
T-SQL - Return custom error message and end query
Rounding milliseconds in T-SQL
Map bitwise enum to sql column value
Building sql query with count() where count() is > 1

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!