> to_char(DOCUMENT.doc_date,'dd/mm/yyyy') --> 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 just write: WHERE <datetime> BETWEEN <<datetime>|<vaild datestring>> AND <<datetime>|<vaild datestring>> Ain't one able to do the kind of same in Oracle? With other words: do you really need to convert the first operand into a char string? -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
