Skip to Content

I want to add the date to oracle in the format dd-mm-yyyy HH;ss

May 07, 2017 at 07:39 AM


avatar image
Former Member


My table is like this

Create table neDailyinfo ( User_id Integer, User_name varchar(20), Today_Date DATE);

but here the case is with my system i am getting date as 01-may-2017 but i want to insert date along with time as dd-mmm-yyyy HH:ss so please help me to do this in oracle databse .

so how i need to create table to accept date as dd-mmm-yyyy HH:ss because i am not adding date manually i am adding date by another method so help me to resolve this.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
May 30, 2017 at 12:53 AM

Oracle's 'date' data type is a misnomer as it also carries time information.

On most other DB systems (and also on MaxDB) you need to use a 'timestamp' data type instead.

10 |10000 characters needed characters left characters exceeded