Results 1 to 2 of 2

Thread: weeknum out of date

  1. 02-11-2003, 03:51 AM #1
    hpeter
    hpeter is offline Registered User
    Join Date
    Dec 2002
    Posts
    5

    weeknum out of date

    does somebody has a clue how to get the weeknum out of a date in oracle?

    e.g. 01.01.2003 => weeknum 1
    Reply With Quote Reply With Quote
  2. 02-23-2003, 03:14 PM #2
    Tiamiyu
    Tiamiyu is offline Registered User
    Join Date
    Feb 2003
    Location
    NA
    Posts
    3
    select to_char(sysdate,'WW') from dual
    will give you the current week number


    I hope this answers your questions


    Tiamiyu Sala
    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