Re: Time conversions

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: 21 Aug 2006 02:34:24 -0700
Message-ID: <1156152864.638843.207550@i42g2000cwa.googlegroups.com>

rj schreef:

> Hi all,
>
> I have a temp table with data to upload to the real table.
> In this temp table there are time values stored as varchar, but are in
> the format dd hh:mm:ss.
> The problem in some of the values are e.g 00 00:91:31; 00 00:81:57
> etc..
> When i try uploading this to the real table with data type interval day
> (2) second (6) I get an error saying that Minutes should be between 0
> and 59.
>
>
> How do I convert these values to that they will fix the
> days/hours/minutes before updating the real table?
>
> Thanks in advance..

Use the correct format mask in your update. DD HH24:MI:SS looks like one, but there are only 60 minutes in an hour the last time I checked, and you have 81, or even 91. You'll have to rework that.

Table definitions and actual update statement would help, as well as version(s) Received on Mon Aug 21 2006 - 04:34:24 CDT