Kbase P8472: How to access DATE and TIME functions using SQL89?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to access DATE and TIME functions using SQL89?
GOAL:
How can the DATE and TIME functions be accessed using SQL89?
FACT(s) (Environment):
Progress 8.x
Progress 9.x
UNIX
Windows
FIX:
To access the DATE function, the following SQL89 statement can be executed:
SELECT DATE FROM <tablename>;
To access the TIME function, the following SQL89 statement can be executed:
SELECT TIME FROM <tablename>;
where <tablename> is the name of the specific table you are attempting to obtain data from.