Compare date issue

Toad Data Point & Toad Intelligence Central
1

Conversion of date when in compare

2

Hi Dangelo,

Can you describe the problem in more detail? Screenshots, steps to reproduce the problem, etc, are helpful.

Also, let us know which version of Toad you are using.

Thanks.

-John

3

Hello John

I am using the compare option in Toad for the environment in Oracle and Teradata. The issue I am having is when a date is involved or numeric data. In Oracle I need to remove the timestamp to do the compare. What is the best way to do this?

4

I am using TOAD 5.4.0.360 Toad Data Point

5

Hi D'Angelo,

This is the Toad for Oracle forum. I'll move the thread to the Data Point forum. Someone else should be able to help you there.

-John

6

That is exactly what I need

1 Like
7

I am using Oracle

8

I am using Oracle. The date is in date and timestamp

9

I need to know on the Oracle database to remove timestamp when comparing data

10

If you want to update the table to remove the time information, and be left with only date, it's

update table mytable
set mydatefield = trunc(mydatefield)
where....

That will set the time to midnight. But I don't know if this is what you are really trying to do. You can't really "Remove" the time info. You may still see the time info as midnight after you do that.

If you just want to not see the time info, then you can just select the date in your query, like:

select TO_CHAR(mydatecolumn, 'DD-MON-YYYY') as mydatecolumn
from mytable
where.....