NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
J-4
JULIANTIMESTAMP Function
The query returns the following data:
The IS NULL predicate is applied to the DEPT_NUM column of the DEPT table
because it appears in the join predicate and belongs to the table that is not preserved.
A null value marker (?) in the column indicates that for a given department number
in the EMPLOYEE table, there is no matching department number in the DEPT
table. You can refine the report by eliminating columns selected from the DEPT
table, as follows:
SELECT E.LAST_NAME, E.FIRST_NAME, E.DEPT_NUM
FROM EMPLOYEE E LEFT JOIN DEPT D
ON E.DEPT_NUM = D.DEPT_NUM
WHERE D.DEPT_NUM IS NULL
The query returns the following data:
JULIANTIMESTAMP Function
JULIANTIMESTAMP is a function that converts a date-time value into a 64-bit Julian
timestamp that represents the number of microseconds that have elapsed between 4713
B.C., January 1, 00:00 and the specified date-time value.
JULIANTIMESTAMP returns a value of type LARGEINT. You can use
JULIANTIMESTAMP anywhere SQL allows a numeric expression.
date-time-expression
is an expression that evaluates to a value of type DATETIME, DATE, TIME, or
TIMESTAMP.
If date-time-expression does not contain all the fields from YEAR through
FRACTION, SQL extends the value (using the EXTEND function rules) before
converting it to a Julian timestamp.
Smythe Roger 7690
??
Smith John 7690 ??
Smythe Roger 7690
Smith John 7690
JULIANTIMESTAMP ( date-time-expression )