Hi.
i have some issues in date conversions.
i have a input file .dat which has a column calendar dt and a .txt file which has a column valuedate. i have to join these 2 column to load the data into table.
i have used stringtodate conversion for valuedate and kept the calendar dt as it is. both should have date as their datatype.
eventhough no warnings data is passing after join stage.
please let me know does calendar dt also needs a conversion? i did the same "stringtodate" but still not working.
guide me what to do.
thanks in advance,
Deepak
Date Conversions
Moderators: chulett, rschirm, roy
Re: Date Conversions
Deepak,
Can you please give the Date values for the source and also how should be value in Target.
Please give the Data Types for the Calendar_dt and Value Dt.
Do you want to Concat both the date values based on key?
What should be the Data Type for the Target Column.
Thanks & Regards,
Anil
Can you please give the Date values for the source and also how should be value in Target.
Please give the Data Types for the Calendar_dt and Value Dt.
Do you want to Concat both the date values based on key?
What should be the Data Type for the Target Column.
Thanks & Regards,
Anil
Deepakinstyle wrote:Hi.
i have some issues in date conversions.
i have a input file .dat which has a column calendar dt and a .txt file which has a column valuedate. i have to join these 2 column to load the data into table.
i have used stringtodate conversion for valuedate and kept the calendar dt as it is. both should have date as their datatype.
eventhough no warnings data is passing after join stage.
please let me know does calendar dt also needs a conversion? i did the same "stringtodate" but still not working.
guide me what to do.
thanks in advance,
Deepak
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
Re: Date Conversions
Hi Anil,
thx for the reply.
data is same for both the columns
its in mm/dd/yyyy format.
thx,
Deepak
thx for the reply.
data is same for both the columns
its in mm/dd/yyyy format.
thx,
Deepak
anil411 wrote:Deepak,
Can you please give the Date values for the source and also how should be value in Target.
Please give the Data Types for the Calendar_dt and Value Dt.
Do you want to Concat both the date values based on key?
What should be the Data Type for the Target Column.
Thanks & Regards,
Anil
Deepakinstyle wrote:Hi.
i have some issues in date conversions.
i have a input file .dat which has a column calendar dt and a .txt file which has a column valuedate. i have to join these 2 column to load the data into table.
i have used stringtodate conversion for valuedate and kept the calendar dt as it is. both should have date as their datatype.
eventhough no warnings data is passing after join stage.
please let me know does calendar dt also needs a conversion? i did the same "stringtodate" but still not working.
guide me what to do.
thanks in advance,
Deepak
Re: Date Conversions
Deepak,
Can you give some example.
Left_Key_val Calender_dt Right_Key_val2 valuedate
1 10/09/2007 1 10/09/2007
2 10/08/2007 2 10/07/2007
What is the output you need ? Do you want Inner join , Left Outer or Right outer Join.
Please reply.
Thanks ,
Anil
Can you give some example.
Left_Key_val Calender_dt Right_Key_val2 valuedate
1 10/09/2007 1 10/09/2007
2 10/08/2007 2 10/07/2007
What is the output you need ? Do you want Inner join , Left Outer or Right outer Join.
Please reply.
Thanks ,
Anil
Deepakinstyle wrote:Hi.
i have some issues in date conversions.
i have a input file .dat which has a column calendar dt and a .txt file which has a column valuedate. i have to join these 2 column to load the data into table.
i have used stringtodate conversion for valuedate and kept the calendar dt as it is. both should have date as their datatype.
eventhough no warnings data is passing after join stage.
please let me know does calendar dt also needs a conversion? i did the same "stringtodate" but still not working.
guide me what to do.
thanks in advance,
Deepak
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
Re: Date Conversions
Hi Anil,
Cal Dt : 09/04/2007 (around 20k record woth same date)
val Dt: 09/04/2007 (1 record)
Cal Dt : 09/04/2007 (around 20k record woth same date)
val Dt: 09/04/2007 (1 record)
anil411 wrote:Deepak,
Can you give some example.
Left_Key_val Calender_dt Right_Key_val2 valuedate
1 10/09/2007 1 10/09/2007
2 10/08/2007 2 10/07/2007
What is the output you need ? Do you want Inner join , Left Outer or Right outer Join.
Please reply.
Thanks ,
Anil
Deepakinstyle wrote:Hi.
i have some issues in date conversions.
i have a input file .dat which has a column calendar dt and a .txt file which has a column valuedate. i have to join these 2 column to load the data into table.
i have used stringtodate conversion for valuedate and kept the calendar dt as it is. both should have date as their datatype.
eventhough no warnings data is passing after join stage.
please let me know does calendar dt also needs a conversion? i did the same "stringtodate" but still not working.
guide me what to do.
thanks in advance,
Deepak
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: