LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rebecca_robare

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!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

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

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rebecca_robare

That works, thank you!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: samsons

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