Formatting dates on insert or update - Helprequired please

Similar Threads:

1.[Info-Ingres] Formatting dates on insert or update - Helprequired please

2.[Info-Ingres] Formatting dates on insert or update - Help required please

3.Formatting dates on insert or update - Help required please

Hi Richard,

    Hope you've got your Jandals on for this one... :-)

    Why not use the simple method of SQL, here are two examples for DD-
MMM-YYYY and YYYYMMDD etc...

SELECT
    RIGHT('00'+VARCHAR(date_part('DAY',hht_start_date)),2)+'-'+
    RIGHT(LEFT('JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC,',
               (INT2(date_part('MONTH',hht_start_date)) * 4) - 1
              ),3)+'-'+
    RIGHT('0000'+VARCHAR(date_part('YEAR',hht_start_date)),4) AS
start_date1,

    RIGHT('0000'+VARCHAR(date_part('YEAR',hht_start_date)),4)+
    RIGHT('00'+VARCHAR(date_part('MONTH',hht_start_date)),2)+
    RIGHT('00'+VARCHAR(date_part('DAY',hht_start_date)),2) AS
start_date2,

   Just swap hht_start_date for 'today' or your local variable etc...

   Enjoy

Gary

4.[Info-Ingres] Formatting dates on insert or update - Help requiredplease

5.To insert Dates in a particular format (with day of the week)

6. INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE

7. INSERT and UPDATE of ALLBALLS/INFINITY dates and

8. INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE COLUMNS