Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

WRT_8229 DATABASE ERROR

Status
Not open for further replies.
sunflower30

sunflower30

Technical User
Jan 4, 2006
1
US
Hi I am trouble with the date format in Teradata. My source and target is teradata.
CREA_DATE -- DATATYPE string
CREA_DATE_OUT(target)-- DATATYPE date

I have tried cast(db_stg.crea_date as date format 'YYYYMMDD')
AND TO_DATE(TRUNC(CREA_DATE))

I keep getting the same error. Can anyone please tell me a way around this problem.
 
Status
Not open for further replies.

Similar threads

sa0309
  • Locked
  • Question
Passing an Oracle SP error message to Informatica Email Task
Replies
0
Views
93
sa0309
sa0309
Tim1988
  • Locked
  • Question
Setting up access Database
Replies
1
Views
56
SkipVought
S
SQLScholar
  • Locked
  • Question
Advantage Database Server
Replies
1
Views
68
SQLScholar
SQLScholar
jkc58
  • Locked
  • Question
Access Error 430
Replies
0
Views
54
jkc58
jkc58
MINIACS
  • Locked
  • Question
"Invalid date, time or timestamp" error - Pervasive 10
Replies
0
Views
67
MINIACS
MINIACS

Part and Inventory Search

Sponsor

Back
Top