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!

Dates with php and oracle 12c

user588690Sep 21 2017 — edited Sep 22 2017

hello,

i am am trying to insert all the input values from the php along with the oracle date part Using a stored procedure.Php won't send the date part. I am entering the date part in the insert command like

to_date(sysdate,'YYYY-MM-DD HH24:MI:SS')

however if I query the database the date components field is looking like this

0021-09-17 00:00:00

Can you you guys help me understand what's going wrong, this value again will be pulled into tableau to do sorting And tableau is not able to intrepret it properly.

thanks

This post has been answered by Frank Kulash on Sep 21 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2017

Added on Sep 21 2017

10 comments

559 views