SQL Server 2005 Cast-Convert Date Time Format
- Get link
- X
- Other Apps
Using CAST function in SQL Server 2005:
Syntax:
CAST (expression as datatype)
CAST function accepts expression name as column name or any SQL function that return expression or value and declare the datatype of the expression into which you want to cast/convert it.
Following are the SQL Server 2005 query syntax to cast DateTime into varchar:
E.g.:
USE Pubs
select cast(pubdate as varchar) from titles
or
select cast(getdate() as varchar)
Following are the MS SQL Server 2005 query Syntax to convert Time format:
SQL query to convert Time format into hh:mm:ss:
select convert(varchar, getdate(), 108)
SQL query to convert Time format into hh:mi:ss:mmm(24h):
select convert(varchar, getdate(), 114)
You can use datetime type column name instead of getdate() function.
E.g.:
USE PUBS
select convert(varchar,pubdate,108) from titles
or
select convert(varchar,pubdate,114) from titles
- Get link
- X
- Other Apps
Comments