[ www.netezza.com ]
Up to Discussions in Enzee Universe

This Question is Possibly Answered

1 "correct" answer available (4 pts) 2 "helpful" answers available (2 pts)
3 Replies Last post: Dec 17, 2009 9:30 AM by Chris Rodgers  
pat.prashant  
pat.prashant
7 posts since
Oct 30, 2009
Currently Being Moderated

Dec 2, 2009 6:44 AM

ERROR:  Bad timestamp external representation ' '

We've encountered this error a few times while processing our loads in Netezza. We use 'select now()' to insert the current timestamp into a column in the Log table. Since we have concurrent jobs running, it may so happen that multiple commands are issued within a second.

 

Could this be the cause of the error? If yes, what could be the possible resolution. Any help would be appreciated. Thanks!

Tags: timestamp", error, "bad
Shawn Fox  
Shawn Fox
520 posts since
Aug 15, 2006
Currently Being Moderated
1. Dec 2, 2009 8:41 AM in response to: pat.prashant
Re: ERROR:  Bad timestamp external representation ' '

The error is telling you that you are trying to insert '' into a timestamp field.

 

create temp table testtab ( tm timestamp );

insert into testtab values ('');

ERROR:  Bad timestamp external representation ''

Report Abuse
pat.prashant  
pat.prashant
7 posts since
Oct 30, 2009
Currently Being Moderated
2. Dec 4, 2009 2:08 AM in response to: Shawn Fox
Re: ERROR:  Bad timestamp external representation ' '

Thanks Shawn, but we're pretty sure there are no '' (null) values being inserted into a timestamp field.

 

We always use 'select now()' everywhere. Could this fail to return a valid timestamp as a result of which the error is being generated?

Report Abuse
Chris Rodgers  
Chris Rodgers
171 posts since
Sep 19, 2006
Currently Being Moderated
3. Dec 17, 2009 9:30 AM in response to: pat.prashant
Re: ERROR:  Bad timestamp external representation ' '

Did you try using the CURRENT_TIMESTAMP reserved word instead of 'select now()'?

Report Abuse

More Like This

  • Retrieving data ...