ImmanuelUlmer
asked on
Regional Settings independent sql strings (date, time)
Hello Experts,
I send SQL strings from VB and MSAccess to SQL2k and SQL2005 DB's.
How can I make sure that the string is regional settings and DB Language independent?
Is the ISO format (yyyy-mm-dd) doing this?
select * from table where insdate = '2006-08-04'
Immanuel
I send SQL strings from VB and MSAccess to SQL2k and SQL2005 DB's.
How can I make sure that the string is regional settings and DB Language independent?
Is the ISO format (yyyy-mm-dd) doing this?
select * from table where insdate = '2006-08-04'
Immanuel
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
convert (varchar (10), insdate, 121) = '2006-08-04'