Max date

[lakshmivijay]

Hello

i've small problem in mysql.

in my table i've 2 dates fields createdon,modifiedon.

How can i get which is latest modified record(i.e either record modified date or record created date)

please help me any one its urgent to me

thanks for any help.

[vamsi616]

Hi,

I think while storing date first time both createdon and modifiedon will be same and if any user logged in 2nd time i suppouse you are updating modifiedon data with currentdate and time. So if you are looking for latest modified record in the table then go with createddon desc and if you are looking when user last loggedin then go with modifiedon date

Thanks,

[lakshmivijay]

But i need to check both dates

[vamsi616]

Yeah,

check both dates in the sense , are you looking which date is maximum one ?

[lakshmivijay]

yes which date is latest one

[vamsi616]

Yeah,

correct me if i am wrong

I think while storing date first time both createdon and modifiedon will be same and if any user logged in 2nd time i suppouse you are updating modifiedon data with currentdate and time.

If that is the case always modified date is latest date

[bubbisthedog]

Or you could change your table structure such only one date field exists and another field represents what the date type is ('created', 'modified', etc.). Then all you'd have to do is query the date field...

[chazzy]

couldn't you use a case statement?


SELECT
case
when mod_date > create_date then mod_date else create_date end as the_date
from your_table


But the design seems iffy at best to me...

[lakshmivijay]

its working

Thanks for ur reply Dear Chazzy.