The following table contains examples of specifying dates, assuming that the date today is March 20, 2014.
|
Sample Statement |
Value Returned |
|---|---|
|
DATE() |
20 Mar 2014' (Defaults to today's date) |
|
DATE('D') |
'14' |
|
DATE('N','2003080') |
'21 Mar 2014' |
|
DATE('U','20030322','S') |
'03/22/14' |
|
Copyright © 2014 CA Technologies.
All rights reserved.
|
|