FAQ
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


--------------------------------------------------------------------------
NOTICE: Morgan Stanley is not acting as a municipal advisor and the opinions or views contained herein are not intended to be, and do not constitute, advice within the meaning of Section 975 of the Dodd-Frank Wall Street Reform and Consumer Protection Act. If you have received this communication in error, please destroy all electronic and paper copies and notify the sender immediately. Mistransmission is not intended to waive confidentiality or privilege. Morgan Stanley reserves the right, to the extent permitted under applicable law, to monitor electronic communications. This message is subject to terms available at the following link: http://www.morganstanley.com/disclaimers. If you cannot access these links, please notify us by reply message and we will send the contents to you. By messaging with Morgan Stanley you consent to the foregoing.

Search Discussions

  • Martin J. Evans at Jun 10, 2011 at 3:45 pm

    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-users @
categoriesperl
postedJun 9, '11 at 2:18p
activeJun 10, '11 at 3:45p
posts2
users2
websitedbi.perl.org

People

Translate

site design / logo © 2022 Grokbase