Chittibabu

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

You can also use the above example to convert the date or datetime formats.

To learn how to convert date format in SQL Server 2005 click here