Problem updating "avail_since" field in the cs_cart_product table

General General Questions
1

I have created a perl program to update a lot of things of cscart automatically



And now I have a problem. I dont know how it is codificated the “avail_since” field in th cscart_product table



I mean



I fill the date fields of an article in the administration area. FOr example, “12/7/2011” and then in the cscart_product table appears the following number “2132144553” (It is only an example and the numbers are not real)



I don´t know how can i insert a date in the cscart_products table manually (in the avail_since field)??





I have more than 20.000 products, and I need to do it by a perl program, I can not update the products manually



Thanks in advance

2

[quote name='tendabit online' timestamp='1315676046' post='121406']

I have created a perl program to update a lot of things of cscart automatically



And now I have a problem. I dont know how it is codificated the “avail_since” field in th cscart_product table



I mean



I fill the date fields of an article in the administration area. FOr example, “12/7/2011” and then in the cscart_product table appears the following number “2132144553” (It is only an example and the numbers are not real)



I don´t know how can i insert a date in the cscart_products table manually (in the avail_since field)??





I have more than 20.000 products, and I need to do it by a perl program, I can not update the products manually



Thanks in advance

[/quote]





That is epoch time. See this as they give you ways to do the conversion in pretty much any language including perl.

3

[quote name='whiplash13' timestamp='1315747130' post='121444']

That is epoch time. See this as they give you ways to do the conversion in pretty much any language including perl.

[/quote]





thanks veru much it worksss!!!