mysql conversion - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

mysql conversion

Author

Topic

dcummiskey
Starting Member

26 Posts

Posted - 2004-11-03 : 18:35:49

Hi -
How would would you write this query to work on MySQL?

select DATEADD(wk, DATEDIFF(wk,0,getdate()), -7)

thanks!
Dan

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-11-03 : 19:15:49

You have posted in a MS SQL Server forum. You might want to post this on a MySQL forum such as:

http://www.dbforums.com/f5

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources