RE: date handling in sql server 2005 express

ition. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: Friday, December 16, 2011 1:19 PM To: profoxt...@leafe.com Subject: Re: date handling in sql server 2005 express Thanks for the info R

Re: date handling in sql server 2005 express

Thanks for the info Rafael El 16/12/2011 11:38, Stephen Russell escribió: > On Thu, Dec 15, 2011 at 4:03 PM, Rafael Copquin > wrote: >> Yes it does, however I need to determine the language and date format >> beforehand, so I can switch automatically from one format to the other, >> without hav

Re: date handling in sql server 2005 express

On Thu, Dec 15, 2011 at 4:03 PM, Rafael Copquin wrote: > Yes it does, however I need to determine the language and date format > beforehand, so I can switch automatically from one format to the other, > without having to change all my sql statements. > I am thinking of adding a function to my clas

Re: date handling in sql server 2005 express

I'go for Frank Cazabon's solution Thanks anyways Rafael El 15/12/2011 20:14, Stephen Russell escribió: > Would you consider making the stored procedure in SS ? If you do you can > pass in date type and value to find. > > Just trying to make a simple option idea for you. > > Sent from my iPhone

Re: date handling in sql server 2005 express

Hell yeah. Sent from my iPhone Stephen Russell 901.246-0159 On Dec 15, 2011, at 3:40 PM, "Alan Bourke" wrote: > > > On Thu, Dec 15, 2011, at 05:30 PM, Frank Cazabon wrote: >> Hi Rafael, >> >> you can avoid all of the problems by using a parameter rather than >> passing the date as a >>

Re: date handling in sql server 2005 express

Would you consider making the stored procedure in SS ? If you do you can pass in date type and value to find. Just trying to make a simple option idea for you. Sent from my iPhone Stephen Russell 901.246-0159 On Dec 15, 2011, at 3:34 PM, Rafael Copquin wrote: > Thank you, it works very we

Re: date handling in sql server 2005 express

Yes it does, however I need to determine the language and date format beforehand, so I can switch automatically from one format to the other, without having to change all my sql statements. I am thinking of adding a function to my classes to do that. BTW, I read somewhere that you can create you

Re: date handling in sql server 2005 express

On Thu, Dec 15, 2011 at 16:34, Rafael Copquin wrote: > Thank you, it works very well. In the Spanish SQL it returns Español and > in the English one it returns us_english > > How about the date format? > In Oracle, I use "DATE '2011-12-15'", which I believe is ANSI standard. Does that format work

Re: date handling in sql server 2005 express

On Thu, Dec 15, 2011, at 05:30 PM, Frank Cazabon wrote: > Hi Rafael, > > you can avoid all of the problems by using a parameter rather than > passing the date as a > > Should be always using parameters in all cases when talking to database servers anyway, IMO. -- Alan Bourke alanpbour

Re: date handling in sql server 2005 express

Thank you, it works very well. In the Spanish SQL it returns Español and in the English one it returns us_english How about the date format? Rafael El 15/12/2011 18:21, Lou Syracuse escribió: > Select @@LANGUAGE might do the trick. Returns us_english on my SQL servers > here in the US. > > L

Re: date handling in sql server 2005 express

Hi Rafael, you can avoid all of the problems by using a parameter rather than passing the date as a string: PRIVATE MyDate MyDate = DATE() && or DATETIME() TEXT TO m.lcSQL TEXTMERGE NOSHOW SELECT invdate FROM Invoices WHERE invdate = ?m.MyDate ENDTEXT SQLEXEC(thisform.nHandle

RE: date handling in sql server 2005 express

Select @@LANGUAGE might do the trick. Returns us_english on my SQL servers here in the US. Lou -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: Thursday, December 15, 2011 1:12 PM To: profoxt...@leafe.com