Re: PROBLEM

Yes I always arguing that its better to store date as an ordinary int "Justin French" <justin@indent.com.au> wrote in message news:B96F27AE.BCBE%justin@indent.com.au... > I don't store anything in date format (eg YYYY-MM-DD)... I store them as a > unix time stamp -- see time() in the manual. > > Then it would be pretty easy to get today's stamp using time(), then look > for the two files preceeding that stamp, (ORDER BY in SQL) which would > presumably be today's file/row, and the one preceeding it (usually > yesterday, but could be a few days before). > > something like: > SELECT * FROM table WHERE stamp < $now ORDER BY stamp DESC LIMIT 2 > > should give you the two stamps you need... a simular thing could be done > with other date formats in MySQL, but I've never worked with them sorry, > > > justin french > > > > > > on 01/08/02 5:43 PM, Thomas Edison Jr. (thomasedisonjr@yahoo.com) wrote: > > > hi! > > i have a problem in my project.the problem is that > > suppose we have the date for the whole of the month > > and two different files r there. > > i have to pick one file of the current date that is > > say today and the other file of the yesterday.but the > > problem is that if the current date is monday then the > > in yesterday file i have to pick for saturday and not > > the sunday.broadly speaking i mean to say that the > > difference between the today's date and yesterday's is > > not fixed as there can be a holiday for say 4 days > > inbetween then in yesterday i need the date 4 days > > before. > > so i need some query to handle this as soon as > > possible as its very urjent.the query should be in > > MYSQL.that is the query should be such which can pick > > today's date and the date of the working day before > > the today's or the current date. > > > > ===== > > Rahul S. Johari (Director) > > ****************************************** > > Abraxas Technologies Inc. > > Homepage : http://www.abraxastech.com > > Email : abraxastech@yahoo.com > > Tel : 91-4546512/4522124 > > ******************************************* > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Health - Feel better, live better > > http://health.yahoo.com >