In "back In Stock Notification" Email I Need To Show The Date And Time

back in stock issue:



i created one extra column in cscart_product_subscriptions table name as “date” in that i stored the date and time, when the user requested for that product



In mail i need to show the date and time,that mail content was came from back_in_stock_notifications.tpl(skins/basic/mail/)…in that i want to access the product id and user id and date from cscart_product_subscriptions table



in that back_in_stock_notifications.tpl i can get the product name but only with product name how can i get the date because same product name can have no of requests





mail content:

-----------------------





[font=arial, sans-serif][size=3]Dear Customer,[/size][/font]



[font=arial, sans-serif][size=3]Good News! The product that you are interested in,paracetmol is back in stock! [/size][/font]

[font=arial, sans-serif][size=3]Please click [/size][/font][font=arial, sans-serif][size=3] to view the product detail page, and to place your order.[/size][/font]



[font=arial, sans-serif][size=3]This automated 'Back in Stock' information email has been sent to you as per your request dated [/size][/font]





[font=arial, sans-serif][size=3]Happy Shopping! [/size][/font]









so please help me…