Stack Overflow
Stack Overflow

Questions tagged [systimestamp]

SYSTIMESTAMP is an Oracle built-in function that returns the system date, including fractional seconds and time zone, of the system on which the database resides. The return type is TIMESTAMP WITH TIME ZONE.

21 questions
0
votes
4 answers

Oracle timestamp and Interval

I have a requirement to get records from a table that are systimestamp > LAST_UPDATE_TS + 5 minutes interval Could you please help with query? ORACLE DB - 11G Version. I have tried this as below but not working as expected. SYSTIMESTAMP :…
Vicki
  • 43
  • 7
0
votes
0 answers

interval between systimestamp problem (oracle)

I have a procedure TTT. v_start_date TIMESTAMP; v_delta_interval interval day to second; begin v_start_date := SYSTIMESTAMP; /* some code */ v_delta_interval := SYSTIMESTAMP - v_start_date; insert into tmp_log_table values (v_start_date,…
DTR
  • 1
  • 1
0
votes
1 answer

how to add HH:MI to systimestamp in PLSQL code with a HH:MI as variable

I want to replace '02:00' with a variable in the below code in PLSQL procedure. SELECT SYSTIMESTAMP + interval '02:00' HOUR TO MINUTE INTO est_close_date FROM DUAL;
Abdul Baqi Syed
  • 3
  • 1
0
votes
1 answer

Oracle query between two timestamps not returning records

I am trying to get all records in the database that have an update date between the interval of systimestamp -15 minutes, to the current systimestamp. So what I do is: and (CAST (update_date AS TIMESTAMP) at time zone 'UTC') BETWEEN …
A.D
  • 25
  • 6
0
votes
2 answers

How can I replace date in oracle systimestamp

I can only use specific basedate value(YYYYMMDD) at my query. I'd like to insert data with timestamp but just replaced with that date INSERT INTO table (field1, field2, regTs) VALUES (:field1, :field2, systimestamp); from this query, how can I…
abend0
  • 227
  • 2
  • 8
0
votes
1 answer

Oracle: Select Milliseconds from Timestamp Type that Defaults with SYSTIMESTAMP

I have a column with TIMESTAMP type in my Oracle Database. The default column value is SYSTIMESTAMP. I want to SELECT milliseconds FROM the TIMESTAMP column. I use the query below without success: SELECT TO_CHAR (MY_TIMESTAMP, 'dd-mm-yyyy…
Vahid
  • 3,384
  • 2
  • 35
  • 69
1
2