Converting Date field to text

[matpj]

I have a table with about 6 fields, one of which is a date/tie field.

All fields in this table are updated by a lotus notes agent from a Notes database.

I need to add another step to the process to then convert the date field to a text field.

Can anyone suggest how I may do this?
It would have to be a script of some description that I could schedule to run after the Notes-Oracle update.

thanks in advance,


Matt
London (UK)

 

[Custom24]

update MyTable set MyTextCopy = to_char(theDateField, 'DDDD-MM-YYYY HH:MI:SS');

or am I missing something?



Mark

 

[matpj]

that seems to simple.
I'm always trying to find very difficult was to solve problems...
thanks for that, i'll give it a go...


Matt
London (UK)