Add Current Date to Query Results Table

Toad for IBM DB2
1

Hello,

I started using Toad a few weeks ago and am transferring old queries from Hyperion Interactive Reporting Studio to Toad Data Point. For the most part I've been able to figure everything out. I'm having trouble with one of my queries though. In this specific one we would have a column in the results table that had the current date in it. For the life of me I can't figure out how to do this in TDP. Does anyone know how to do this?

2

I am not exactly sure of what you are asking or what Toad feature you are using.
If you are running a DB2 query in the SQL Editor and want the current date in the result set you could use the query below as a template:
image

Hope this helps...

3

This is exactly what I was looking for. Thank you!!

1 Like