var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Insert with a convertion
I use ASE 188.8.131.52
I need to insert data from a table TAB2 to another TAB1 with convertion of a field which is in timestamp to a datetime
I must do something like that:
INSERT INTO TAB1(DATETIME)
SELECT (procedure timestamp2datetime on timestamp fied) from TAB2
I absolutely need to use ma procedure in the insert.
I thought about a loop (for,if,while), but I didn't manage to make it work.
Thanks for your help
Create a proxy table on your procedure
then insert select from proxy table
But why can you not insert from your procedure?
I manage to do what I want.
I did it with a fetch which treat the select records by records.