newbie: how convert nvchar to datetime?
- From: Jim Muir <jpmuirNoSpamPlease@xxxxxxxxx>
- Date: Sun, 23 Oct 2005 08:39:39 -0400
I have imported a table into msSQL (2000)
One of the fields which was stored originally as a simple date field (05/05/05) was created as nvarchar(8).
How to I alter this column to become a DateTime field type? I want to do this before I add any more records.
The application will be sending a date like 10/23/2005 but without the time part.
.
- Follow-Ups:
- Re: newbie: how convert nvchar to datetime?
- From: Hari Prasad
- Re: newbie: how convert nvchar to datetime?
- Prev by Date: Re: Matching fileds between two tables
- Next by Date: Re: newbie: how convert nvchar to datetime?
- Previous by thread: Re: Matching fileds between two tables
- Next by thread: Re: newbie: how convert nvchar to datetime?
- Index(es):
