DB2 Insert Current TimeStamp

DB2 Insert Current TimeStamp

DB2 Insert Current TimeStamp In DB2 CURRENT TIMESTAMP is inherited as below: CURRENT_TIMESTAMP is equivalent to specifying CURRENT TIMESTAMP Suppose you want timestamp with specified precision then this can be referenced as CURRENT TIMESTAMP(integer) where integer can range from 0 … Continue reading

Insert Date SQL Database example

Insert Date SQL Database example

Insert Date SQL Database example To insert date value to the table where its column defined as date. In this example we will insert both date and datatime value to the table. Let’s first create table: