Results 1 to 2 of 2

Thread: Find the max and min Date

  1. 02-01-2001, 10:10 PM #1
    Andy Wong Guest

    Find the max and min Date

    I'm doing a query using SQL Server. How can I get the max and min date from a database? I can't find any function related to it. Can you help me please ....

    Thanks in advance
    Andy
    Reply With Quote Reply With Quote
  2. 02-02-2001, 08:39 AM #2
    Paul Guest

    Find the max and min Date (reply)


    SELECT TOP 1
    <date>
    ORDER BY <date> DESC

    SELECT TOP 1
    <date>
    ORDER BY <date> ASC

    ------------
    Andy Wong at 2/1/01 10:10:28 PM

    I&#39;m doing a query using SQL Server. How can I get the max and min date from a database? I can&#39;t find any function related to it. Can you help me please ....

    Thanks in advance
    Andy
    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