Re: Q: forms 10G date format

From: SteveC <stevec_at_sfsu.edu>
Date: 13 Mar 2006 14:28:56 -0800
Message-ID: <1142288936.372760.232880_at_i40g2000cwc.googlegroups.com>


[Quoted] To use Alter Session in forms, enclose it witin a Forms_DDL command:

[Quoted] Forms_DDL('ALTER SESSION SET NLS_DATE_FORMAT=''YYYYMMDDHH24MISS''');

If you are going to use #Between, you are strictly entering pure sql where-clause code, so all client-side date formats will be ignored. Users might like using the ANSI date function: #Between date'2006-03-15' and date'2006-03-31' Received on Mon Mar 13 2006 - 23:28:56 CET

Original text of this message