MAKETIMESTAMP Function

Returns the timestamp.

Category: Date and Time
Returned data type: timestamp
Syntax
Arguments
Example
See Also

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
 
select maketimestamp(y, m, d, h, mn, s) from adate;

30OCT2013:13:39:10

See Also

Functions:
DATEPART Function
MAKEDATE Function
MAKETIME Function
TIMEPART Function
Copyright © SAS Institute Inc. All rights reserved.