A script-enabled browser is required for this page to function properly.

ORA_NLS.AMERICAN_DATE built-in function

This function returns TRUE or FALSE, depending on whether the current date format is "American".

Syntax


FUNCTION ORA_NLS.AMERICAN_DATE
RETURN BOOLEAN;

Returns

TRUE or FALSE.

Example


/*
** 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;

See also

About the ORA_NLS built-in package

ORA_NLS built-in package