Results 1 to 2 of 2

Thread: SQL Question

  1. Jun 11th, 2000, 08:26 PM #1
    Nathan
    Nathan is offline

    Thread Starter
    Addicted Member
    Join Date
    May 2000
    Posts
    188
    I need to retrieve only the date part of a datetime field in my select statement. Is there any way to do this?
    Reply With Quote Reply With Quote
  2. Jun 11th, 2000, 09:51 PM #2
    Nathan
    Nathan is offline

    Thread Starter
    Addicted Member
    Join Date
    May 2000
    Posts
    188

    GOT IT

    Had to use CONVERT(Char, Date, 101) As Date in the SQL Select Statement
    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