MAKETIMESTAMP Function

Returns the timestamp.

Category: Date and Time
Returned data type: timestamp

Syntax

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

Arguments

d,t

d

specifies the date.

t

specifies the time.

y,m,d,h,m,s

y

specifies the year.

m

specifies the month.

d

specifies the day.

h

specifies the hours.

m

specifies the minutes.

s

specifies the seconds.

Example

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
Last updated: February 23, 2017