ORACLE)

SELECT 1,2,3 FROM DUAL

UNION ALL

SELECT 0,1,2 FROM DUAL;

         1          2          3

---------- ---------- ----------

         1          2          3

         0          1          2

SELECT

    SYSDATE

FROM DUAL;

SYSDATE

--------

03/11/21

IBM DB2)

WITH

 TEST (a, b, c) AS

 (VALUES (1, 2, 3)

 UNION ALL

  VALUES (0, 1, 2))

SELECT a,b,c FROM TEST;

A           B           C         

----------- ----------- -----------

          0           1           2

          1           2           3

SELECT TEST.A, TEST.B, TEST.C

FROM (VALUES (1, 2, 3), (0, 1, 2)) AS TEST (A, B, C);

A           B           C         

----------- ----------- -----------

          1           2           3

          0           1           2

values(current date);

1        

----------

2003-11-21

values(hex(current date));

1      

--------

20031121

values(char(current date, iso));

1        

----------

2003-11-21

values(char(current date, eur));

1        

----------

21.11.2003

values(char(current date, usa));

1        

----------

11/21/2003

values(char(current time));

1      

--------

15:04:53

values(hex(current time));

1    

------

150654

values(char(current timestamp));

1                        

--------------------------

2003-11-21-15.04.53.392101

values(hex(current timestamp));

1                   

--------------------

20031121150654406165