ORA_NLS.AMERICAN_DATE
built-in functionThis function returns TRUE
or FALSE
, depending on
whether the current date format is "American".
FUNCTION ORA_NLS.AMERICAN_DATE
RETURN BOOLEAN;
TRUE
or FALSE
.
/*
** Determine if date format is American
*/
PROCEDURE is_amerdate (out TEXT_IO.FILE_TYPE) IS
usd BOOLEAN;
BEGIN
usd := ORA_NLS.AMERICAN_DATE;
IF usd = TRUE
THEN
TEXT_IO.PUT (out, 'Date format is American');
ELSE
change_date_to_us;
ENDIF;
END;
About the ORA_NLS
built-in package
Copyright © 1984, 2005, Oracle. All rights reserved.