DSXchange

Hi all,

My source is text file having one column date value is "1/28/2008 1:46:55 PM",this date i have to populate in a SQL server

While loading i am getting error like "1/28/2008 1:46:55 PM is an Invalid date"

Can any one let me know how can i resolve this problem.

Regards,
Mohan

Change the format to one acceptable to SQL Server, particularly CCYY-MM-DD HH:MM:SS or CCYY-MM-DD HH:MM:SS.sss

Split the input into date and time. Use Iconv() and Oconv() functions to reorganize both, then concatenate with a space between.

I am able to split date part ,but How to split the time portion
Is there any function to split the time portion.

Regards,
Mohan

Use a substring expression, in this case the date and time are separated by a " " (space), so the date would be "FIELD(In.Column," ",1)"

But, because there is a space ahead of your AM/PM designator, you need a variation, as I posted in my original answer, which is a complete solution.

Do purchase premium membership. Revenue from premium membership is totally devoted to helping to defray the hosting and bandwidth costs incurred by DSXchange. And you'll be able to read premium posters' contributions in their entirety.

ray.wurlod wrote:Change the format to one acceptable to SQL Server, particularly CCYY-MM-DD HH:MM:SS or CCYY-MM-DD HH:MM:SS.sss

Split the input into date and time. Use Iconv() and Oconv() functions to reorganize b ...

Find the date formate in squl server and use the Iconv() and Oconv() functions .

example is Oconv(Iconv(DSLink44.END_DATE[1,10],"D4/"),"D-DMY[,A,]") , go to help and select as per your formate

Hi,

To split the time part alone as per your Date format, try Right function

Right("1/28/2008 1:46:55 PM",10) will result - 1:46:55 PM

Thanks & Regards - gsym

Mohandl,

I had similar requirement and my issue was resolved .Please look at thsi
post .

viewtopic.php?t=107975&highlight=

Thanks
Paddu