on 05-29-2014 12:26 PM
Hi chenna,
Hope this helps!
SELECT Sale_ID, Cast(null as Date) as order_date, CAST("Sale Transaction".Sale_Date as date) as s_date
FROM "Sale Transaction"
UNION
SELECT Sale_ID, Cast("Order Transaction".order_date as Date) as order_date, Cast(null as Date) as s_date
FROM "Order Transaction"
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Chenna,
Check the data types for the two columns that you believe are dates - one may not be a date and may need a to_date conversion or similar.
Regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Mark,
How can I set default value to new field(null as order_date) when I create derive table by using UNION in IDT?
If I change the top sql to button than new field(null as s_date) will display blank.
Best regards,
Chenna Yon
Dear Mark ,
I don't how to cast null value to default date.
Can you provide me sql statement as cast null value to date as default in IDT?
Best regards,
Chenna Yon
Hi Chenna,
Just an observation, why your second select statement has Order Date in Quotes.(i.e. "Order Date" as order_date)
Can you try selecting the same directly from the list?
I believe Order Date is your database field and not text.
Thanks
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Check both the date type as selected as Date or not.
Select the Business Layer à select the objects à Check the data type
And also select the Order date from Order Transaction table as said by Gaurav Saxena
Expand the Order Transaction Table --> Select the Order date
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.