Mayfield2268 Posted January 16, 2004 Posted January 16, 2004 I'm using the following SQL in a aspx page with vb.net SELECT LNAPPLSA_TB.INTVW_NR AS EMPLOYEE, LOANAPPL_TB.APPL_DT FROM LNAPPLSA_TB, LOANAPPL_TB WHERE LNAPPLSA_TB.LOAN_APPL_NR = LOANAPPL_TB.LOAN_APPL_NR AND LOANAPPL_TB.APPL_DT > '30-DEC-03' A dataset is generated and binded to a datagrid. When I run the page, all data is returned. All records before '30-DEC-03' and after are displayed in the datagrid even though only records after '30-DEC-03' should be shown. When I use Oracle SQL*Plus it works fine. Does anyone know why this might be happening. Quote
Moderators Robby Posted January 17, 2004 Moderators Posted January 17, 2004 change LOANAPPL_TB.APPL_DT > '30-DEC-03' to something like that LOANAPPL_TB.APPL_DT > to_char('30-DEC-03', "DD-MMM-YY") Quote Visit...Bassic Software
iebidan Posted January 20, 2004 Posted January 20, 2004 nah, I think that he needs to use the TO_DATE, only if the datatype of the column is DATE, if it's a VARCHAR2, something very common used by oracle developers use the TO_CHAR Quote Fat kids are harder to kidnap
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.