Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-19 : 16:11:13
|
Lars writes "hi,
i am importing with a VB application some parts of an ASCII file into a SQL table. but when i am converting datafields into the datetime column the value "0000000" is converted to 30 dec 1899. Is there maybe a way in my import stored procedure to convert the value to "0000000" when it encounters this value from the ASCII file? hope you guys can help me out!
thanx
here is my stored procedure which imports the values within the VB application
create procedure vmtemptest_isrt
@naam varchar (34),
@place varchar (24),
@dateofbirth datetime ,
@license varchar (6),
@address varchar (29),
@postal varchar (6)
as
begin
insert into vmtemptest
(naam,
plaats,
geboortedatum,
kenteken,
adres,
postcode)
values (@naam ,
@place ,
@dateofbirth ,
@license,
@address,
@postal)
end
GO" |
|
|
|
|
|
|
|
stored procedure and importing datatime values