CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. October 23rd, 2005, 08:04 PM #1
    bradleyc
    bradleyc is offline Junior Member
    Join Date
    Aug 2005
    Posts
    22

    sql*plus or pl/sql question

    How would you calculate the difference between two dates?
    Reply With Quote Reply With Quote
  2. October 23rd, 2005, 08:25 PM #2
    bradleyc
    bradleyc is offline Junior Member
    Join Date
    Aug 2005
    Posts
    22

    Re: sql*plus or pl/sql question

    Apparently i should use DATEDIFF ... how do i use DATEDIFF?
    Reply With Quote Reply With Quote
  3. October 24th, 2005, 12:02 AM #3
    Ejaz's Avatar
    Ejaz
    Ejaz is offline Elite Member Power Poster
    Join Date
    Jul 2002
    Location
    Lahore, Pakistan
    Posts
    4,211

    Re: sql*plus or pl/sql question

    DateDiff Function
    Regards,
    Ejaz.

    Browse Articles, Read AUP, Use Code Tags, Check FAQs
    How To Ask Questions The Smart Way?
    Reply With Quote Reply With Quote
  4. October 24th, 2005, 12:38 AM #4
    trends
    trends is offline Junior Member
    Join Date
    Oct 2005
    Location
    India
    Posts
    24

    Talking Re: sql*plus or pl/sql question

    hi ,

    try this.

    datediff( 'mm', d1, d2 ).where mm is month.for date you give dd.ok
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured