Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vvekaria
Starting Member
1 Post |
 Posted - 2005-10-31 : 12:02:58
|
| Hi,I need to insert dates into a mysql temporary table. I need to explicitly state the date in the script so next time I just come in and change that date and the columns get filled using that date as it's source.I need (from 15th Oct 2005 for example):Column called FN will hold daily dates for the last 2 weeks (fortnight);Column called YTD will hold daily dates from year to date;Column called PrevYear will hold daily dates for last 12 months;Any ideas? Many Thanks in advance!Regards,Vijay |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-10-31 : 12:34:25
|
| http://sqlteam.com/askus.asp |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-10-31 : 12:40:22
|
| mysql questions are probably better handled over at dbforums. SQLTeam is SQL Server specific, so you probabaly won't get much help here.http://www.dbforums.com/f5-ec |
|
|
|
|
|
|
mysql: Loop for dates