Help | Site Map

Join Bytes
Login

network: 226,295 (2644 online)

bytes

get latest date record

SunshineInTheRain SunshineInTheRain is offline

SunshineInTheRain is offline

Newbie

Join Date: Jan 2008

Posts: 14

#1: Aug 17 '08

I have a log table.

I want to get record of latest date. Meaning if 1-May-2008 13:32:22 and 1-May-2008 2:22:21, it will retrieve 1-May-2008 13:32:22 as a result.

how the statement should be?

thaanks in advanced.

ck9663 is offline

Expert

Join Date: Jun 2007

Posts: 1,925

#2: Aug 18 '08

re: get latest date record

Use MAX

-- CK

Reply

« previous question | next question »

Similar Microsoft SQL Server bytes

can i get any help writing this program? (answers)
output the latest date for each foreign key (answers)
Finding Latest Record for an Associate (answers)
REQ How would I compare multiple date fields in one table to find the latest entry (answers)

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,295 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml

it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved