Retrieve last inserted date from the database

jignesh1

guy i want to retrive the last date i insert into database.
for example i inserted 2007-01-02

Piranha

do you have a column where the date you insert the row is inserted? If not then create one.

jignesh1

i have a column name called report_date
but i want to retrive the last date from the column

bradgrafelman

SELECT MAX(`date_column`) FROM `myTable`)

would be the generic syntax.

EDIT: Then again, I might not be understanding - do you want the lastest date? Or just whatever date was entered last? If it's the latter of the two questions, you'd probably need some sort of auto incrementing id field to sort by.

jignesh1

i wanted the last date but the date are inserted in ASC order
for example 2007-01-01 would be before 2007-01-02

bradgrafelman

Okay... so... does that answer your question then?

jignesh1

When i try

SELECT MAX('report_date') FROM 'Report';

i tried that it gave me a error

when i try this

SELECT MAX('report_date') FROM report

it doesnt print anything

bradgrafelman

Well, try using my query.

Note that I used backticks ( ` ) to denote column/table names, not single quotes.

jignesh1

that worked thanxs for the help
im not going to marked this thread resolve i need more help on this

Weedpacket

If "that worked" then that's the problem resolved. If you have other problems then those would be other threads.

jignesh1

thanxs for the help