Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to add days, hours, minutes and seconds to a date?

user639304Jun 29 2011 — edited Jul 8 2011
Hi,

I have the following problem.
Given 4 integers D,H,M and S (each of them can be negative) and a date Da, I want to add D days, H hours, M minutes and S seconds to the date Da.
For example, if
Da= to_date('28/06/2011 14:50:35','dd/mm/yyyy HH24:mi:ss'), and D = 3, H = -2, M = 20 and S = -12, 
it means I want to add 3 days, -2 hours, 20 minutes and -12 seconds to the date Da, and the new date must be the following date:
to_date('01/07/2011 13:10:23','dd/mm/yyyy HH24:mi:ss') 
Is it possible to write a query to solve this problem or should I use PL/SQL?

Thanks.
This post has been answered by 6363 on Jun 29 2011
Jump to Answer

Comments

rober584812

Hello SmithJohn45.
Try the next commands:

systemctl start oracle-xe-21c
systemctl enable oracle-xe-21c

After running the commands, reboot and test the connection to SQLPLUS.
Regards.

SmithJohn45

thanks @rober584812 but it is already mentioned in guide and off course i executed those commands to start database audomatically.
image.png

rober584812
Answer
Marked as Answer by SmithJohn45 · Oct 1 2021
SmithJohn45

thanks again, will check it and give you feedback

SmithJohn45

@rober584812 here is my feedback...
this helped me and now I can connect to my PDB.
thanks very much for help :)

SmithJohn45

hi rober584812
it was connected to my PDB but when I restart my CentOS 7 VM now it is not connecting to XEPDB1
i issued 2 ' Alter Pluggable Database ' commands ( as below ) but still failed to connect using sys/ora1234@xepdb1
in my .bash_profile i added following environment variables which can only enable me to run sqlplus, also i have to issue command manually as below to connect to XE (CDB) but this also not allowed me to connect to PDB.
. oraenv
alter commands as per oracle documents:

alter PLUGGABLE DATABASE ALL OPEN;
alter PLUGGABLE DATABASE ALL SAVE STATE;

environment variables:
export ORACLE_BASE=/opt/oracle/
export LD_LIBRARY_PATH=$ORACLE_BASE/product/21c/dbhomeXE/lib
export ORACLE_HOME=$ORACLE_BASE/product/21c/dbhomeXE
export PATH=$ORACLE_BASE/product/21c/dbhomeXE/bin:$PATH
export PATH=/usr/bin:$PATH
export ORACLE_SID=XE
this is same problem i am facing in 18c XE. please help to connect and start Apex 21 + ORDS 21 installation and development.
regards
Is it necessary to issue , oraenv command ? what about if i add it in .bash_profile but will this accept XE as parameter in that file?

rober584812

Hello SmithJohn45 , check if the listener is running.

cd <oracle_home>/bin
lsnrctl status

After, if the listener status is OK, try the following command:
system/password@localhost.localdomain:1521/XEPDB1
The order . oraenv is necessary.
Regards.

SmithJohn45

yeah, i can connnect using ezconnect syntax. but as mentioned earlier, i am confused as i want to install Apex & ORDS, how I can configure to use it both " . oraenv " and ezconnect syntax without every time manually interact when logout and login, machine restart etc. and same for production environment?
regards

rober584812

Hello @smithjohn45 , the important thing is that the listener is working, if the listener is in the OK state, you will be able to access the Oracle XE instance without problems; Regarding the installation of APEX with ORDS, using "oraenv" will be required during the installation process, you can configure ORDS in autorun or standalone mode.
Regards.

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 5 2011
Added on Jun 29 2011
3 comments
11,428 views