MAKETIMESTAMP Function

Returns the timestamp.

Category:	Date and Time
Returned data type:	timestamp

Syntax

MAKETIMESTAMP(d,t)

MAKETIMESTAMP(y,m,d,h,m,s)

specifies the date.

specifies the time.

specifies the year.

specifies the month.

specifies the day.

specifies the hours.

specifies the minutes.

specifies the seconds.

The following statements illustrate the MAKETIMESTAMP function:

Statements	Results
select maketimestamp(date '2013-10-30', time '10:39:10');	30OCT2013:10:39:10
select maketimestamp(2013,10,30,13,39,10);	30OCT2013:13:39:10
select maketimestamp(makedate(2013, 10, 30), maketime(13, 39, 10));	30OCT2013:13:39:10

Statements

Results

select maketimestamp(date '2013-10-30', 
time '10:39:10');

30OCT2013:10:39:10

select maketimestamp(2013,10,30,13,39,10);

30OCT2013:13:39:10

select maketimestamp(makedate(2013, 10, 30),
 maketime(13, 39, 10));

30OCT2013:13:39:10