Link to home
Create AccountLog in
Avatar of Zolf
ZolfFlag for United Arab Emirates

asked on

sql query help


Hello there,

i have a table which had a createddate and updateddate col. now i want to query this table to return the last date a product was update.how can i get it.

cheers
zolf
Avatar of Zolf
Zolf
Flag of United Arab Emirates image

ASKER


please help
ASKER CERTIFIED SOLUTION
Avatar of mimran18
mimran18
Flag of United Arab Emirates image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Strange. How that table works? There is a record for each time the product was updated? Or update date only stores the first/last update?
Avatar of Zolf

ASKER


>>There is a record for each time the product was updated?
no,the updatedDate col is edited everytime the product is edited
Avatar of Zolf

ASKER

thanks