Top "Sysdate" questions

SYSDATE is an Oracle specific SQL function which serves to give the current date and time of the database.

Check if current date is between two dates Oracle SQL

I would like to select 1 if current date falls between 2 dates through Oracle SQL. I wrote an SQL after reading …

Read More
sql oracle date between sysdate
to_date function with sysdate

select TO_CHAR(to_date(sysdate, 'DD-MON-YYYY'), 'DAY') FROM DUAL; When I run this query the output was : SUNDAY. But …

Read More
oracle oracle10g oracle11g sysdate
How can I use DB side default value while use Hibernate save?

I have a column in DB with default value as sysdate. I'm looking for a way to get that default …

Read More
hibernate jpa default sysdate
Oracle subtracting days and minutes

I want to subtract "X" days and "X" minutes from sysdate, where the days and minutes are an integer as …

Read More
oracle sysdate
Update Sysdate - 10 min in Oracle

I need to update a date column, with sysdate but 10 mins past. Is there any way to do? Please help.

Read More
oracle sysdate
Append sysdate to a table name in Oracle

I need to append SYSDATE while creating a table in Oracle. Please let me know if there is a direct …

Read More
oracle sysdate
SQL TRUNC Minutes from Sysdate

I am currently using one of the columns to extract every minute of the time, however, it would skip some …

Read More
sql oracle datetime timestamp sysdate
How to convert sysdate to UTC time in oracle

I am having a query to subtract a date from the sysdate. However the date object I have is in …

Read More
sql oracle datetime sysdate
What is the equivalent of ORACLE's SYSDATE in Impala?

I have a WHERE clause I am trying to convert from ORACLE SQL into Impala SQL. The col2 output looks …

Read More
sql oracle impala sysdate
sysdate and dbtimezone different in Oracle Database

With this query: select sysdate from dual; the result is: 27-09-2018 07:50:50 -- this UK time with : Select dbtimezone from …

Read More
sql oracle timezone sysdate