Results 1 to 4 of 4

Thread: Acquiring Timestamps with Msec from Oracle

  1. #1
    Contributor
    Join Date
    Feb 2015
    Location
    Philadelphia
    Posts
    10

    Default Acquiring Timestamps with Msec from Oracle

    I've chipped away at this one for a few days and finally have to admit bafflement.

    I'm pulling in a set of data from our Oracle database that includes timestamps down to the millisecond: 01.52.09.829000 AM.

    When I pull this directly into Lavastorm using the select statement in a DB Query node, the msec information is removed, so I have CAST the timestamp into a string: cast(fd.start_ts as varchar(35)) as api_start_time.

    I have been able to pull out and format the date from that string, and the individual components of the time. However, when I use
    API_TIME_B = time(API_24,API_MIN,API_SEC,API_MSEC) I receive the error message "operator takes 0-3 parameters, not 4".

    How do I get these timestamps down to the millisecond?

    Thanks!

  2. #2
    Lavastorm Employee stonysmith's Avatar
    Join Date
    Nov 2006
    Location
    Grapevine Tx
    Posts
    799

    Default

    You will need to include the DATE portion of the expression, but this should work:

    dt=date(API_Year,API_Month,API_Day)
    tm=time(API_24,API_MIN,API_SEC)
    API_TIME_B = timestamp(dt,tm)+API_MSEC

  3. #3
    Contributor
    Join Date
    Feb 2015
    Location
    Philadelphia
    Posts
    10

    Default

    That works, thank you!

  4. #4

    Default

    i think that i have chipped away at this one for a few days and finally have to admit bafflement.,,,,,,,,,,,,

Tags for this Thread

Posting Permissions

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