How to insert date values into table

Question

How can I insert into table with different input using      with date datatype   insert into run id name dob values  amp id   amp name   what should I write here       I m using  oracle 10g

User · Answer

I simply wrote an embedded SQL program to write a new record with date fields. It was by far best and shortest without any errors I was able to reach my requirement.

_x000D_

w_dob = %char(%date(*date));      
exec sql insert into Tablename (ID_Number     , 
                             AmendmentNo   , 
                             OverrideDate  , 
                             Operator      , 
                             Text_ID       , 
                             Policy_Company, 
                             Policy_Number , 
                             Override      , 
                             CREATE_USER   ) 
                values ( '801010',    
                            1,            
                           :w_dob,      
                           'MYUSER',     
                            ' ',         
                            '01',        
                            '6535435023150', 
                            '1',         
                            'myuser');

_x000D_

User · Answer

date must be insert with two apostrophes  As example if the date is 2018 10 20  It can insert from these query  Query -   insert into run id name dob values  amp id   amp name   2018-10-20

User · Answer

let suppose we create a table Transactions using SQl server management studio  txn id int   txn type id varchar 200    Account id int   Amount int   tDate date       with date datatype we can insert values in simple format   yyyy-mm-dd   INSERT INTO transactions  txn id txn type id Account id Amount tDate  VALUES  978   DBT   103  100   2004-01-22      Moreover we can have differet time formats like   DATE - format YYYY-MM-DD DATETIME - format  YYYY-MM-DD HH MI SS SMALLDATETIME - format  YYYY-MM-DD HH MI SS

User · Answer

insert into run id name dob values  amp id   amp name   what should I write   here       insert into run id name dob values  amp id   amp name  TO DATE   amp dob   YYYY-MM-DD

User · Answer

Since dob is DATE data type  you need to convert the literal to DATE using TO DATE and the proper format model  The syntax is   TO DATE   lt date literal gt      lt format model gt      For example   SQL gt  CREATE TABLE t dob DATE    Table created   SQL gt  INSERT INTO t dob  VALUES TO DATE  17 12 2015    DD MM YYYY      1 row created   SQL gt  COMMIT   Commit complete   SQL gt  SELECT   FROM t   DOB ---------- 17 12 2015   A DATE data type contains both date and time elements  If you are not concerned about the time portion  then you could also use the ANSI Date literal which uses a fixed format  YYYY-MM-DD  and is NLS independent    For example   SQL gt  INSERT INTO t dob  VALUES DATE  2015-12-17     1 row created

User · Answer

You can also use the  quot timestamp quot  data type where it just needs  quot dd-mm-yyyy quot  Like  insert into emp values  12-12-2012     considering there is just one column in the table    You can adjust the insertion values according to your table

[sql] How to insert date values into table

Examples related to sql

Examples related to oracle

Examples related to datetime

Examples related to oracle10g

Examples related to date-formatting