How to query the date and time in SQL statement?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How to query the date and time in SQL statement?

Hybrid View

  1. #1
    Ken Guest

    How to query the date and time in SQL statement?


    How to query by date and time in ACCESS SQL statement? If I wanted a record
    after 12/01/00 9:00:00 AM, how do I write SQL statement in ACCESS?

    Thanks lot!

  2. #2
    Jay Guest

    Re: How to query the date and time in SQL statement?


    SELECT Blah,balh,blah FROM yourTable
    WHERE (((Date)>#12/1/2000 9:0:0#));

    Jay

    "Ken" <kzhao@calltrol.com> wrote:
    >
    >How to query by date and time in ACCESS SQL statement? If I wanted a record
    >after 12/01/00 9:00:00 AM, how do I write SQL statement in ACCESS?
    >
    >Thanks lot!



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center