Time in Wrong Format

[abbaddon223]

Hi,

I have a db with a text field in it. In this a time is stored in a pretty poor format, example:

01:23

Meaning 1 minute and 23 seconds. I would have expected this to be:

00:01:23

But alas this is not the case.

I'm really struggling to get the first format into the second. Could anyone help me with this at all please?

Cheers,

Phil.

 

[pr2-eugin]

The Data type for the Time field is setup wrong. It should be Date/Time not Text. Changing the field's type now will only result in disaster, create a New column with the proper type and then port it (use a User Defined Function maybe), then delete the old field and rename the new field to that of the old field.

 

[abbaddon223]

Hi,

Thanks for the response - not responsible for building the db mercifually!! Thanks I'll try that....