date error

ravindrag · Post by **ravindrag** » Tue Oct 10, 2006 9:04 am

i have a datecolumn 2055/12/09 with date datatype i have to populate to target datatype timestamp i.e to MSOLEDB but it is comming as 2055/00/00 i have tried 2055/00/00 : " " : Oconv( Time(), "MTS:" ) and
2055/00/00 :00:00:00 but it is not working

2.And i have to check a date if it is valid i have to load to target date datatype is date(8)

thanks in advance

kris007 · Post by **kris007** » Tue Oct 10, 2006 9:22 am

From what it looks like your date datatype is of length 8 and you are trying to insert data whose length is greater than that. That is where you will need to look at. or are your point 1 and 2 two different scenarios?

DSguru2B · Post by **DSguru2B** » Tue Oct 10, 2006 10:58 am

What is your source and target???
The date format seems to be ok.And if Oconv(Time(), MTS) is giving you all zeros, then there is something else going on. Try loading the output to a flat file and check the format.

diamondabhi · Post by **diamondabhi** » Tue Oct 10, 2006 12:40 pm

Might as well try 2055/00/00:" ":"00:00:00"

ray.wurlod · Post by **ray.wurlod** » Tue Oct 10, 2006 2:04 pm

2055/00/00 is not a date. Maybe that's the issue. Try 2055/01/01.

ravindrag · Post by **ravindrag** » Tue Oct 10, 2006 10:10 pm

first and second points are different scenarios my source is sequential file and target is msoledb stage. when iam loading to flatfile it is working fine but it is coming as 2500/00/00 :00:00 when i am loading to database stage

ray.wurlod · Post by **ray.wurlod** » Wed Oct 11, 2006 1:18 am

Then, clearly, there is something amiss with your derivation. Please post the derivation expression you used.