-
1. Re: Cast from null to timestamp problem
rareddy Nov 18, 2010 11:25 AM (in response to jalen)Is this error you are seeing when executing from Designer? I executed following from SquirreL fine against 7.2 Final Teiid.
select cast(null as timestamp) as t from pm1.g1
select convert(null, timestamp) as t from pm1.g1Ramesh..
-
2. Re: Cast from null to timestamp problem
shawkins Nov 18, 2010 12:56 PM (in response to rareddy)Jalen,
What query are you executing in Designer, or is this just from a preview? As Ramesh is getting at the error you are seeing is more than likely not directly related to the converion of a null to timestamp. Perhaps there is something in the definition of T where are a source column of type int has been given a runtime type of timestamp.
Steve
-
3. Re: Cast from null to timestamp problem
jalen Nov 19, 2010 1:08 AM (in response to shawkins)This sql is written in the Designer.
We use it deploy the VDB to JBoss and execute it.
-
4. Re: Cast from null to timestamp problem
rareddy Nov 21, 2010 8:44 PM (in response to jalen)You can give us a sample test VDB with your issue, we will check this out.
-
5. Re: Cast from null to timestamp problem
jalen Nov 23, 2010 1:14 PM (in response to rareddy)Do you only need the VDB file? Is that enough?
Thanks for your patience.