Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    16

    Question Unanswered: Insert with a convertion

    Hi,

    I use ASE 12.5.0.1
    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

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Create a proxy table on your procedure
    then insert select from proxy table

    But why can you not insert from your procedure?

  3. #3
    Join Date
    Jan 2007
    Posts
    16
    I manage to do what I want.
    I did it with a fetch which treat the select records by records.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •