How can i change varchar to datetime

[Guest]

I have a datetime column in db that stores datetime in varchar format suct
that "20060616120621". I want to get this date in a datetime format to make
comparisions according to that. How can i do that with an SQL Query or c#
code?

Thanks

 

[Sanjib Biswas]

You should call sql function to_date( string1, [ format_mask ], [
nls_language ] ) to convert a string to date format.

 

[pvdg42]

I have a datetime column in db that stores datetime in varchar format suct
that "20060616120621". I want to get this date in a datetime format to
make
comparisions according to that. How can i do that with an SQL Query or c#
code?

Thanks

You don't indicate what kind of database you're using, but in Transact SQL
(for SQL Server), you can use CAST or CONVERT.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

 

[cw]

You don't indicate what kind of database you're using, but in Transact SQL
(for SQL Server), you can use CAST or CONVERT.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

On the .NET side, if you want to convert, use
System.Convert.ToDateTime([date time string])