Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Oct 2007
    Location
    Manila, Philippines
    Posts
    132

    Unanswered: current weekdays

    hi,

    how can I return the current weekdays. mon - current.

    thanks

    Take Nothing But Pictures;
    Leave Nothing But Footprints;
    Kill Nothing But Time;

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    SELECT DAYNAME(CURRENT_DATE)

    this returns Sunday, Monday, etc.

    if you want just 3 characters, use LEFT(DAYNAME(CURRENT_DATE),3) or, alternatively, DATE_FORMAT(CURRENT_DATE,'%a')
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2007
    Location
    Manila, Philippines
    Posts
    132
    thanks
    but it only returns the current day name,
    Code:
    SELECT
    DAYNAME(current_date) as 'current week'
    FROM coding_log
    it suppose to return the current 7 days.
    Code:
    SELECT
    `date`
    FROM coding_log
    where week(`date`) = week(current_date)
    Take Nothing But Pictures;
    Leave Nothing But Footprints;
    Kill Nothing But Time;

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    what is this coding_log table? how many rows in there? can i see samples?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Oct 2007
    Location
    Manila, Philippines
    Posts
    132
    coding_table has many rows, but i only need the `date`, and convert it to weeks. i need week to date of the current day.

    sample is just days that is with in this current week.

    thanks
    Take Nothing But Pictures;
    Leave Nothing But Footprints;
    Kill Nothing But Time;

  6. #6
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    PHP Code:
    SELECT DATE_FORMAT(CURRENT_DATE'%v'); 
    %v gives the week number between 01 and 53, each week beginning on monday.

    For the different formats, see the DATE_FORMAT doc here.

    HTH

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

  7. #7
    Join Date
    Oct 2007
    Location
    Manila, Philippines
    Posts
    132
    thanks,
    my field is
    `date`
    and i want the current week of my field date from mon to fri.
    week(current_date)

    thanks
    Take Nothing But Pictures;
    Leave Nothing But Footprints;
    Kill Nothing But Time;

  8. #8
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    Quote Originally Posted by homer.favenir
    thanks,
    my field is
    `date`
    and i want the current week of my field date from mon to fri.
    week(current_date)

    thanks
    And can't you try ???

    Code:
    SELECT `date`
    FROM coding_log
    where date_format(`date`, '%v') = date_format(current_date, '%v');
    will return rows for which the date field is in the current week.

    Isn't it what you want ?
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

  9. #9
    Join Date
    Oct 2007
    Location
    Manila, Philippines
    Posts
    132
    yes it is, thanks
    isnt this the same?
    where week(`date`) = week(current_date);
    Take Nothing But Pictures;
    Leave Nothing But Footprints;
    Kill Nothing But Time;

  10. #10
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    Quote Originally Posted by homer.favenir
    yes it is, thanks
    isnt this the same?
    where week(`date`) = week(current_date);
    Yes, week() also works. Choose the second parameter wisely though.

    I didn't know of it and it was not clear for me that you had solved your problem .

    Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

  11. #11
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by homer.favenir
    i need week to date of the current day.
    what does "week to date" mean?

    so you're not interested in the name of the day of the week?

    when you ask a question, you really should give more information, with lots of sample data and an indication of what you want to return from that sample data
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  12. #12
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by homer.favenir
    i want the current week of my field date from mon to fri.
    well, today is wednesday (at least, it is over here)

    so you want thursday and friday of this week too? and why not sunday and saturday?

    and do you actually want data from your coding_log table at all, or are you just interested in the dates themselves?

    so you see what i mean about asking unclear questions?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  13. #13
    Join Date
    Oct 2007
    Location
    Manila, Philippines
    Posts
    132
    saturday and sunday is ok. as long it is the current week.
    week to date is the current week of the month or year.
    i like to have a list of current week from my field `date`.
    the query should return the current week from the field `date`
    i will use the query in my php program, thats why i just need the`date` field only that returns current week.

    thanks
    Take Nothing But Pictures;
    Leave Nothing But Footprints;
    Kill Nothing But Time;

  14. #14
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the current week is a single number

    so "a list of the current week" doesn't make sense to me

    also, "the query should return the current week from the field `date`" doesn't make sense, assuming that there is more than one row with different values of `date`

    could you perhaps try something different? how about showing a few sample rows of your table, and then tell us what you want the query to return from those rows
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  15. #15
    Join Date
    Oct 2007
    Location
    Manila, Philippines
    Posts
    132
    these are the values of my field `date`
    Code:
    dtestarted
    2008-04-08 19:48:47
    2008-04-08 20:22:24
    2008-04-08 20:10:38
    2008-04-17 08:44:40
    2008-04-17 08:19:40
    2008-04-17 08:51:40
    2008-04-17 09:11:17
    2008-04-17 12:41:40
    2008-04-18 10:16:31
    2008-04-18 09:50:51
    2008-04-18 09:35:35
    2008-04-18 15:26:01
    2008-04-18 15:21:58
    2008-04-18 15:15:56
    2008-04-19 11:40:47
    2008-04-19 16:16:25
    2008-04-19 16:02:35
    2008-04-19 17:15:44
    2008-04-19 18:34:40
    2008-04-19 18:37:14
    2008-04-19 18:57:50
    2008-04-19 17:30:23
    2008-04-19 16:31:03
    2008-04-21 08:26:46
    2008-04-19 20:00:00
    2008-04-19 19:51:17
    2008-04-19 19:41:23
    2008-04-19 19:05:28
    2008-04-24 07:13:40
    2008-04-24 07:26:13
    2008-04-23 10:18:28
    2008-04-28 19:22:06
    2008-04-29 01:52:17
    2008-05-01 01:06:03
    2008-05-01 00:43:11
    2008-05-01 00:22:33
    2008-05-03 00:13:46
    2008-05-02 22:50:48
    2008-05-02 22:28:59
    2008-05-03 03:36:29
    2008-05-03 03:12:17
    2008-05-03 04:44:28
    2008-05-03 04:32:36
    2008-05-04 03:13:46
    2008-05-04 02:24:23
    2008-05-04 05:08:07
    2008-05-03 02:49:05
    2008-05-03 02:36:09
    2008-05-06 04:15:07
    2008-05-06 04:12:55
    2008-05-06 19:18:14
    2008-05-05 19:40:53
    2008-05-07 00:33:24
    2008-05-08 22:31:28
    2008-05-08 21:46:14
    2008-05-06 19:47:39
    2008-05-09 22:23:25
    2008-05-07 01:48:56
    2008-05-07 03:56:28
    2008-05-07 03:48:11
    2008-05-08 02:13:21
    2008-05-08 00:50:07
    2008-05-08 00:24:27
    2008-05-09 19:31:37
    2008-05-09 00:47:51
    2008-05-13 07:47:03
    2008-05-15 07:30:57
    2008-05-14 12:39:45
    2008-05-16 10:41:55
    2008-05-16 10:33:48
    2008-05-16 10:19:47
    2008-05-16 09:32:12
    2008-05-17 13:16:48
    2008-05-15 08:50:54
    2008-05-15 12:33:41
    2008-05-20 08:43:58
    2008-05-20 08:31:33
    2008-05-20 09:18:32
    2008-05-21 07:30:51
    2008-05-21 08:34:54
    2008-05-21 10:31:43
    2008-05-22 12:22:32
    2008-05-22 10:26:13
    2008-05-24 10:43:03
    2008-05-29 20:27:00
    2008-05-30 00:05:32
    2008-05-31 02:24:17
    2008-06-04 19:42:54
    2008-06-04 22:47:38
    2008-06-06 20:05:36
    2008-06-05 22:26:37
    2008-06-05 22:06:35
    2008-06-10 15:07:33
    2008-06-12 14:27:07
    2008-06-12 12:30:21
    2008-06-13 10:24:30
    2008-06-14 13:16:49
    2008-06-17 08:33:36
    2008-06-17 07:12:01
    2008-07-15 13:17:38
    2008-07-16 12:18:13
    2008-07-16 10:24:03
    sorry, what i mean is list of days of the current week.
    Take Nothing But Pictures;
    Leave Nothing But Footprints;
    Kill Nothing But Time;

Posting Permissions

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