MySQL Forums
Forum List  »  Microsoft SQL Server

convert function help
Posted by: Rakesh She
Date: November 21, 2005 11:01PM

I am doing something like follow...

select convert( datetime,kokiEnd,111) AS kokiEndFormat from M_PUNCHCARD

where kokiEnd is varchar in my db. I am converting to datetime. As empty values are allowed in my db for colunm kokiEnd I get 1900-01-01 when it is empty I want there "" stirng .
How I can do this?

Regds
Rakesh

Options: ReplyQuote


Subject
Written By
Posted
convert function help
November 21, 2005 11:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.