# Sysdate in query

**URL:** <https://forums.toadworld.com/t/sysdate-in-query/18106>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [April 26, 2013, 4:16am UTC](https://forums.toadworld.com/t/sysdate-in-query/18106 "2013-04-26T04:16:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![julian.chasin\_625](https://avatars.discourse-cdn.com/v4/letter/j/e95f7d/32.png) [@julian.chasin\_625](https://forums.toadworld.com/u/julian.chasin_625)\
**Post date:** [April 26, 2013, 4:16am UTC](https://forums.toadworld.com/t/sysdate-in-query/18106/1 "2013-04-26T04:16:17Z")

</div>

I have a cross-connection query where I’m trying to use sysdate, as in:  
**WHERE (RECALL.DATE\_DUE \>= sysdate)**  
But I get **"Unknown column ‘sysdate’ in ‘where clause’ Make sure that the table is fully qualified…"**

The help for Cross-Connection Query Functions lists sysdate as supported functions.

Using TDA Pro 3.2 on Win 7.

---

<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:** [April 26, 2013, 5:29am UTC](https://forums.toadworld.com/t/sysdate-in-query/18106/2 "2013-04-26T05:29:43Z")

</div>

Cross-connection queries are parsed and process by the TDP Optimizer. Some parts of your query or all of your query may be passed to the origination server. When that happens you can use functions from the originating server. If the part of the query is implemented on this side you have to use a mySQL equivalent function.

I know that sounds confusing. Please see this Blog for a better explanation.

> **[How To Write a Cross-Database Query](https://blog.toadworld.com/2012/11/21/how-to-write-a-cross-database-query)**
>
> How To Write a Cross-Database Query

Debbie

---

<div class="post-metadata">

**Author:** ![julian.chasin\_625](https://avatars.discourse-cdn.com/v4/letter/j/e95f7d/32.png) [@julian.chasin\_625](https://forums.toadworld.com/u/julian.chasin_625)\
**Post date:** [April 26, 2013, 9:33pm UTC](https://forums.toadworld.com/t/sysdate-in-query/18106/3 "2013-04-26T21:33:55Z")

</div>

Thanks, the mysql sysdate() worked.  
I thought I had tried that previously and it had failed, but today it worked.  
I’ll study the blog posting you mentioned; makes for more complicated queries, but I understand the need to drive the data filtering back to the source.