SmallDatetime Conversion?

External Since: May 17, 2007 Posts: 9

I do I convert a field that is "smalldatetime" to "datetime"?

I am doing a select statement from a table and need my output to be
"datetime".

Thanks,
Raj

External Since: Jan 31, 2006 Posts: 335

On Mon, 24 Sep 2007 08:28:06 -0700, Ryan Mcbee wrote:

>I do I convert a field that is "smalldatetime" to "datetime"?
>
>I am doing a select statement from a table and need my output to be
>"datetime".

Hi Raj,

You can simply use

CAST (ColumnName AS datetime)

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis