it works..!
thnx..
-Original Message-
From: Jerry Nelson [mailto:[EMAIL PROTECTED]]
Sent: segunda-feira, 25 de Fevereiro de 2002 16:55
To: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] comparing dates with oracle
Oracle formats it's date differently.
Try this :
between to_date('
Oracle formats it's date differently.
Try this :
between to_date('15/11/1258', 'dd/mm/') and
to_date('15/08/1988','dd/mm/')
*-*---*--*-*-*-**
Jerry Nelson
Project Manager / Analyst
Datanamics, Inc.
973-C Russell Ave
Gaithersburg,
> to_char(DOCUMENT.doc_date,'dd/mm/') --> is for formatting the date
and
>"doc_date" after it is meant as an alias...
>
>any mistake here???
>
>I just need to obtain a code for a date which lies within the
>form inputted date values...
I don't know the Oracle syntax, but with in MS SQL you
-Original Message-
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]]
Sent: segunda-feira, 25 de Fevereiro de 2002 16:35
To: [EMAIL PROTECTED]
Cc: 'Sandeep Murphy'
Subject: RE: [PHP-WIN] comparing dates with oracle
to_char(DOCUMENT.doc_date,'dd/mm/') -
From: Sandeep Murphy
Sent: Monday, February 25, 2002 5:06 PM
>Hi,
>
>I am trying to compare dates between my form fields and my db field but so
>far keep getting a format error.. Am using an Oracle Db...
>
>my query reads like this:
>
>SQL = "SELECT DISTINCT to_char(DOCUMENT.doc_date,'dd/mm/yyy
Hi,
I am trying to compare dates between my form fields and my db field but so
far keep getting a format error.. Am using an Oracle Db...
my query reads like this:
SQL = "SELECT DISTINCT to_char(DOCUMENT.doc_date,'dd/mm/')
doc_date,DOCUMENT.document_code from Document where";
SQL += " doc_
