Updating TechNotes V3.#1 TIME ZONE CONVERSION IN INFORMIX-4GL USING INFORMIX-ESQL/C

Updating TechNotes V3.#1 TIME ZONE CONVERSION IN INFORMIX-4GL USING INFORMIX-ESQL/C

Post by William Da » Sat, 24 Apr 1993 06:34:20



----------------------- FOR INFORMIXLINK-------------------------

TECH ALERT: ERRATA

Missing from the article, Time Zone Conversion in INFORMIX-4GL
Using INFORMIX-ESQL/C, printed in Tech Notes, Volume 3, Issue 1,
1993, was one test program called test_tz.4gl. This test program
is referred to on page 50 of the Tech Notes issue. The program
shows how the time zone functions work and is included below.

------------------------ CUT HERE -------------------------------

test_tz.4gl

------------------------ CUT HERE -------------------------------

MAIN
DEFINE
  dtvar1  DATETIME YEAR TO SECOND,
  dtvar2  DATETIME YEAR TO SECOND,
  dvar1   DATE,
  dvar2   DATE,
  tvar1   CHAR(5),
  tvar2   CHAR(5)

  LET dtvar1 = CURRENT
  DISPLAY "The current local date/time is: ", dtvar1
  CALL dt_loc_to_gmt(dtvar1) RETURNING dtvar2
  DISPLAY "The current GMT date/time is: ", dtvar2
  CALL dt_gmt_to_loc(dtvar2) RETURNING dtvar1
  DISPLAY "The converted local date/time is: ", dtvar1

  LET dvar1 = TODAY
  LET tvar1 = "12:00"

  DISPLAY "The current local date/char is: ", dvar1 USING "mm/dd/yyyy", " ",
  tvar1

  CALL ch_loc_to_gmt(dvar1, tvar1) RETURNING dvar2, tvar2

  DISPLAY "The current GMT date/char is: ", dvar2 USING "mm/dd/yyyy", " ",
  tvar2

  CALL ch_gmt_to_loc(dvar2, tvar2) RETURNING dvar1, tvar1

  DISPLAY "The converted local date/char is: ", dvar1 USING "mm/dd/yyyy", " ",
  tvar1

END MAIN

--
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
 William Daul             Advanced Support      INFORMIX SOFTWARE INC.
 4100 Bohannon Dr.        (415) 926-6488 - wk

 
 
 

1. Req:Informix C/ESQL, 4GL programmer part-time

Required:

- Informix C/ESQL programmer and/or 4gl programmer in Southern
California

- Part-time work during August/September (evenings, weekends,
work-at-home is ok, but onsite meetings in SoCal a must). This position
may be supplemental to an existing job.

- W2 only. You will work part-time for us. Therefore must be green card
or citizen.

If interested, please email resume, salary requirements (hourly rate)

2. Postmaster windows shell

3. INFORMIX-4GL Compiled / INFORMIX-4GL RDS in the same

4. Encripting Access 2000 ?

5. JOB: Informix 4GL or ESQL - P/A - Newport Beach, CA

6. usage of ODBC

7. INFORMIX 4GL/ESQL-C Developers needed

8. Load Tran Problem

9. informix 4GL and ESQL/C