DateTime question

[ianuk77]

Hi all,

Is it possible to get the datetime value of the first and last records in a table then work out the difference between ?


Thanks,

Ian

 

[feherke]

Hi

If the data is in chronological order, so the first is the oldest and the last is the newest date, then is easy :

[b]select[/b]
min([green][i]thefield[/i][/green]),max([green][i]thefield[/i][/green]),datediff(max([green][i]thefield[/i][/green]),min([green][i]thefield[/i][/green]))
[b]from[/b] [green][i]thetable[/i][/green]

Feherke.

http://rootshell.be/~feherke/

 

[ianuk77]

Thanks for the quick reply

Yes the data is in chronological order and the query worked perfect.

Thankyou
Ian