Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Posts
    14

    Thumbs up Unanswered: get month name from a date time

    hi

    i need to get month name from a date time in sql... i don't have any idea to do it... can you explain how i should do it

    my table

    attendance (
    date varchat(50),
    intime datetime
    out time datetime
    e_cid varchar(10)

    )

    i need to get monthly attendance details.then firtst i need to compare it with month ....


    can you explain the way ...


    thanks

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    select datename(month,intime) from attendance

  3. #3
    Join Date
    Aug 2008
    Posts
    14
    thanks for your reply.... iit's very helpfullllllllllllll

Posting Permissions

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