SQL Question

Results 1 to 5 of 5

Thread: SQL Question

  1. #1
    Venkatesh Babu Guest

    Default SQL Question

    I would like to find out the last Day of the month ?<BR>In Sql is there any function to find out, if Yes what is that function, If No how to find out in sql ?<BR>

  2. #2
    Asif Qazi Guest

    Default RE: SQL Question

    U mean to say that u have a month say March 2001 and u want to find out that what was the day(Sat or sunday etc) on the last(31st in this case)date of that month.<BR>Is it like that ??

  3. #3
    Venkatesh Babu Guest

    Default RE: SQL Question

    Suppose you have March 2001, u should get the answer as 31st.

  4. #4
    Join Date
    Dec 1969

    Default RE: SQL Question

    Ok! I was thinking that u r asking about the day name.<BR>U can do that by defining ur enumerated data type for the month at the application level or in sql by using a case for the month names u can find the last date, u can do that in stored procedure.<BR>Hope it will work.<BR>

  5. #5
    Venkatesh Babu Guest

    Default Thanks

    Can you please send me the code .<BR>vbabusk@yahoo.com<BR>

Posting Permissions

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