SRI Technologies

Last Modified
Date: 11-Dec-2005
Time: 03:02:54
Index
Project Name: Gamma Project
System Name: Demonstration System
Application Name: Demo Application
Source File: DEMODATE.SQC
Shared Code Name: Date Procedures
Description: SQC for commonly used date/time procedures
Author: Scott D
Procedure Index:
Sl.NoProcedureDescription
1 DATE-CURR-DATEGet System Current Date
2 DATE-CURR-TIMEGet System Current Time
3 DATE-CURR-DATE-TIMEGet System Time Stamp

Program Change Log:
Sl.NODateAuthorRemark
1.10-Mar-1999Scott.MCreation
2.15-Feb-2002Scott.MIntroduced SqrPlus Documentation
Database Tables:
SLNO.Table NameAccess ModeProcedure NameRemarks
1NoneN/AN/ANot Applicable

Include Files:

  1. None

See Also:

  1. demostr.sqc

Procedures:

  1. Procedure Name: DATE-CURR-DATE
    Procedure Description: Get System Current Date
    Procedure Type: Local

    Arguments/Parameter:
    SLNO.VariableMode
    1$DATEBy Reference

    Database Tables:
    SLNO.Table NameAccess ModeRemarks
    1NoneN/ANot Applicable

    Processing:

    Current Date:

    1. Use date-time () function to retrieve current System date if db_time variable is defined.

    See Also:

    1. DATE-Curr-Time
  2. Procedure Name: DATE-CURR-TIME
    Procedure Description: Get System Current Time
    Procedure Type: Local

    Arguments/Parameter:
    SLNO.VariableMode
    1$TIMEBy Reference

    Database Tables:
    SLNO.Table NameAccess ModeRemarks
    1NoneN/ANot Applicable

    Processing:

    Current Time:

    1. Use date-time () function to retrieve current System time if db_time variable is defined.

    See Also:

    1. DATE-Curr-Date
  3. Procedure Name: DATE-CURR-DATE-TIME
    Procedure Description: Get System Time Stamp
    Procedure Type: Local

    Arguments/Parameter:
    SLNO.VariableMode
    1$DATEBy Reference

    Database Tables:
    SLNO.Table NameAccess ModeRemarks
    1NoneN/ANot Applicable

    Processing:

    Current Time Stamp:

    1. Use date-time () function to retrieve current Time Stamp if db_time variable is defines.

    See Also:

    1. DATE-Curr-Date
    2. DATE-Curr-Time