Insert statement
Hi
Follows my insert statement.
INSERT INTO AppUser(Forename, Surname, Job_Title, DOB, Employee_Number,
User_Type,Employee_Site_ID) values ('J', 'Q', GM, '1955-07-20', 'BMW01',
'E', '2 ');
The DOB fields gets populated with "/" instead of '1955-07-20' as in the
insert . I want to keep the DOB as shown in the insert statement and not
with forward slash '1955/07/20' as saved in the tabel.
Suggestions?
Ta
Nimisha
[564 byte] By [
Nimisha] at [2007-11-9 21:11:23]
# 1 Re: Insert statement
that appears to be an invalid datetime format
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8
_con_03_765d.asp?frame=true
try using yyyymmdd instead
--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions
"Nimisha" <nimisha_uk@yahoo.com> wrote in message
news:3e900ae9$1@tnews.web.dev-archive.com...
>
> Hi
>
> Follows my insert statement.
>
> INSERT INTO AppUser(Forename, Surname, Job_Title, DOB, Employee_Number,
> User_Type,Employee_Site_ID) values ('J', 'Q', GM, '1955-07-20',
'BMW01',
> 'E', '2 ');
>
> The DOB fields gets populated with "/" instead of '1955-07-20' as in the
> insert . I want to keep the DOB as shown in the insert statement and not
> with forward slash '1955/07/20' as saved in the tabel.
>
> Suggestions?
>
> Ta
> Nimisha
# 2 Re: Insert statement
Hi David
I got it figured finally. Had to use a replace and convert funtion.
Thanx for the response
Nimisha
"David Satz" <davidNOSPAMsatz@yahoo.NOSPAM.com> wrote:
>that appears to be an invalid datetime format
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8
>_con_03_765d.asp?frame=true
>
>try using yyyymmdd instead
>--
>HTH,
>David Satz
>Principal Web Engineer
>Hyperion Solutions
>
>"Nimisha" <nimisha_uk@yahoo.com> wrote in message
>news:3e900ae9$1@tnews.web.dev-archive.com...
>>
>> Hi
>>
>> Follows my insert statement.
>>
>> INSERT INTO AppUser(Forename, Surname, Job_Title, DOB, Employee_Number,
>> User_Type,Employee_Site_ID) values ('J', 'Q', GM, '1955-07-20',
>'BMW01',
>> 'E', '2 ');
>>
>> The DOB fields gets populated with "/" instead of '1955-07-20' as in the
>> insert . I want to keep the DOB as shown in the insert statement and not
>> with forward slash '1955/07/20' as saved in the tabel.
>>
>> Suggestions?
>>
>> Ta
>> Nimisha
>
>
