Date data type explanation
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home   
Search
    Guidelines    Member List
Welcome Guest ( Login | Register )
     
Recent Posts
   
Popular Topics

Teradata Discussion Forums » Teradata » Teradata Database » Date data type explanation
This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Date data type explanation Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Simon.Chia
Posted 7/28/2008 11:28:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/29/2008 9:46:31 AM
Posts: 2, Visits: 9
dear all,

we are using teradata as our source system into SAP BI and i have this date format YYYY-MM-DD with the length 4. Can you please explain to me how this works? does 4 means the date format? e.g 3 == (perhaps) mm-yyyy-dd ?

thanks.
Post #12323
CarlosAL
Posted 7/29/2008 2:44:08 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 2 days ago @ 11:52:28 AM
Posts: 12, Visits: 171
DATE is stored as INTEGER in TERADATA.

HTH.

Cheers.

Carlos.
Post #12324
Simon.Chia
Posted 7/29/2008 3:28:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/29/2008 9:46:31 AM
Posts: 2, Visits: 9
so if its integer, how does that explain data type 4? If its 4, what do i get as a result?
Post #12325
CarlosAL
Posted 7/29/2008 6:00:24 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 2 days ago @ 11:52:28 AM
Posts: 12, Visits: 171
((YEAR - 1900) * 10000) + (MONTH * 12) + DAY

31/12/2007 = 1071231

HTH.

Cheers.

Carlos.
Post #12330
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 11:32pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.375. 9 queries. Compression Disabled.