I posted a while back for a solution to make a MySQL DB into a MSQL DB can
anyone help please?
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Oops, you are subtracting the date, so use - 7 instead of + 7...
Dan
-Original Message-
From: Dan Lampkin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 5:05 PM
To: 'DevList'; 'mySQL Mailing List'
Subject: RE: mysql to mssql query
If I understand you
FROM myTable WHERE date_field >= DATEADD(DAY, 7, '2003-10-19')
Dan
-Original Message-
From: DevList [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 4:49 PM
To: mySQL Mailing List
Subject: mysql to mssql query
Does anybody know the equivalent of this query in mssq
Well, even if you don't find an alternative for that syntax, you could
always do the date subtraction in application space and make the query
like this:
SELECT * FROM myTable WHERE date_field >= '2003-10-12'
- Gabriel
On Tuesday, October 21, 2003, at 05:49 PM, DevList wrote:
Does anybody kno
Does anybody know the equivalent of this query in mssql:
SELECT * FROM myTable WHERE date_field >= DATE_SUB('2003-10-19', INTERVAL 7
DAY);
For this project we are pulling records off a MS SQL db, and I need to
figure a way to return all records for the week.
Any help is appreciated.
--
MySQ
hey guys
i got a scenario here i need to extract some CDR records from a Mssql
database into a mysql database and have them available on a website. I have
not really configured odbc before, so i am having some problems, i am
running SuSE 7.2 on my linux box, i got the the source (myodbc) from
m
Hi !!!
> hey guys
>
> i got a scenario here i need to extract some CDR records from
> a Mssql database into a mysql database and have them
> available on a website. I have not really configured odbc
> before, so i am having some problems, i am running SuSE 7.2
> on my linux box, i got the t