Member Avatar for MARKAND911

How to two dates in oracle?

  • 6 Contributors
  • 7 Replies
  • 86 Views
  • 7 Months Discussion Span
  • Latest Post Latest Post by pratik_garg

Recommended Answers

All 7 Replies

Member Avatar for griswolf

RTFM of course.

Member Avatar for MARKAND911

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

Member Avatar for debasisdas

How to what ?

Member Avatar for 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)

Member Avatar for peralivet

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

Member Avatar for hfx642

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

Member Avatar for pratik_garg

DIRECTLY .....

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


simple ... :)

Edited by pratik_garg because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.