Date comparison in oracle

[MARKAND911]

How to two dates in oracle?

[griswolf]

RTFM of course.

[MARKAND911]

hey griswolf
i didnt understand ur answer.
will u please elaborate.

[debasisdas]

How to what ?

[griswolf]

Date comparison is a very straight forward thing to do. You find out how by Reading The Fine Manual. Start here (I could be more specific if I knew which Oracle version you are using)

[peralivet]

You can use to_char($variavle,'month-day-year') is equal to the second one

[hfx642]

What type of comparison are you trying to accomplish?
(Equal Dates, Equal Times, One Date < or > the Other, etc.)

[pratik_garg]

DIRECTLY .....

as how you compare int same equal sign " = " you can apply in dates also...

simple ... :)