date format picture ends before converting entire input string 01830 in asp.net

[rohitjs]

The date format picture ends before converting entire input string 01830 in asp.net

SELECT A,B,C FROM XYZ 
WHERE to_date(accptnc_dttm,'DD-MON-RRRR HH:MM')>='" + datefrom_changed + "' and to_date(accptnc_dttm,'DD-MON-RRRR HH:MM')<'" + dateto_changed + "'

[Frinavale]

Is "01830" a date then?
Is that 1901? 2001?

I think your date string is incorrect and that it isn't being converted properly but it is really hard to tell because you have just posted a code snippet used for selecting some data from the database.

[Killer42]

Ok, I don't know ASP at all, so take all this with a grain of salt. It may all just be down to variation between flavours of SQL. That being said...

• Wouldn't it be more efficient to use the BETWEEN clause, so you only execute the to_date() function half as many times?
• In the SQL I'm familiar with, date constants are delimited by # not '.
• Both opening and closing double-quote characters appear to be missing here, so perhaps we're not seeing the whole picture?

In any case, I think we need more context to understand what's going on here.