Archives of the TeradataForum

Message Posted: Tue, 19 Sep 2006 @ 19:47:10 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I was trying to export result of one simple table from our Test environment and import data from that table on our Dev using SQL Assistant. The table has date column in it. And I am getting message of 'Invalid date supplied for my_testdate.month_end_date'

I am using following SQLs for the task:

1) sel * from sandbox.my_testdate (On TEST environment-SQLA in File>export results mode)

2) created the table structure on sandbox database on Dev environment, saved the exported file on my hard drive

3) insert into sandbox.my_testdate values( ?, ? ,?) (On DEV environment-SQLA in File>import data mode)

My Table structure is:

     CREATE SET TABLE sandbox.my_testdate ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           month_end_date DATE FORMAT 'yyyy/mm/dd',
           month_of_year INTEGER,
           year_of_calendar INTEGER)
     UNIQUE PRIMARY INDEX ( month_end_date );

After export, the text file at my hard drive looks like: (the date display format is different)

     month_end_date    month_of_year    year_of_calendar
     5/31/2046               5               2046
     8/31/1998               8               1998
     4/30/1974               4               1974
     4/30/2092               4               2092
     6/30/2072               6               2072

What I need to do to export/import with such dates with SQLA? Is there any script for such date format conversion? Please help.

Thanks,

Sazia

	<Prev	Next>		<<First	<Prev	Next>	Last>>