# Toad for DA 2.5 - Date comparisons and conversions

**URL:** <https://forums.toadworld.com/t/toad-for-da-2-5-date-comparisons-and-conversions/6334>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [September 24, 2010, 2:49pm UTC](https://forums.toadworld.com/t/toad-for-da-2-5-date-comparisons-and-conversions/6334 "2010-09-24T14:49:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bella.joseph\_187](https://avatars.discourse-cdn.com/v4/letter/b/c89c15/32.png) [@bella.joseph\_187](https://forums.toadworld.com/u/bella.joseph_187)\
**Post date:** [September 24, 2010, 2:49pm UTC](https://forums.toadworld.com/t/toad-for-da-2-5-date-comparisons-and-conversions/6334/1 "2010-09-24T14:49:35Z")

</div>

Hi,

I have an odbc connection from Toad DA to an Oracle Bi server. I am trying to do a simple query : query a table where “Birth Date” \> ‘01/16/1957’

In the target BI server, 'Birth Date" is varchar2, and hence it returns values 01/19/1964, 01/24/1935… 01/24/1935 should not be returned.

How can I use a date function to compare like I would normally do :

select \*  
from …  
where to\_date(“Birth Date”, ‘mm/dd/yyyy’) \> to\_date(‘01/16/1957’, ‘mm/dd/yyyy’)  
The above results in sql syntax error.

Any help would be appreciated!

Thanks!

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [September 29, 2010, 1:38pm UTC](https://forums.toadworld.com/t/toad-for-da-2-5-date-comparisons-and-conversions/6334/2 "2010-09-29T13:38:15Z")

</div>

You would need to look into what functions the driver supports.

Debbie

---

<div class="post-metadata">

**Author:** ![MPompey](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mpompey/32/112_2.png) [@MPompey](https://forums.toadworld.com/u/MPompey)\
**Post date:** [October 6, 2010, 10:04am UTC](https://forums.toadworld.com/t/toad-for-da-2-5-date-comparisons-and-conversions/6334/3 "2010-10-06T10:04:25Z")

</div>

I’m not sure if the text you pasted is actual or a typo but it looks like you have quotes around the Birth\_Date field.