On 09/06/11 15:17, Barapatre, Pariksheet wrote:
Hi All,
I am using DBD::Teradata module for connecting to Teradata server.
I am facing issue with Date columns.
Suppose today's date is 2011-06-09.
Select DATE ;
Above query is giving output as 1110609 instead of 2011-06-09.
Can anybody help me on this?
Thanks
Pariksheet
I don't use Teradata so I could be way off here. Perhaps that is the default
format for dates in your database. Perhaps you can cast it with a format -
select cast(date as date format 'YYYY-MM-DD') - something like that.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
