Last post Jun 20, 2014 05:18 AM by sam_xiii
None
0 Points
4 Posts
Jun 20, 2014 02:56 AM|maswood_silverlight|LINK
hi,
I have a localized website in English and Hebrew.
When I use the isDate() function in english it works fine.
When I use the isDate() function in hebrew it won't work fine. The date passed in both scenarios is in the format "mm/dd/yyyy". E.g (10/25/2014)
Any help in this regard will be much appreciated.
isdate() localization asp.net
Contributor
3630 Points
776 Posts
Jun 20, 2014 05:18 AM|sam_xiii|LINK
Hi
Check http://msdn.microsoft.com/en-us/library/ms187347%28SQL.105%29.aspx#SessionSettingDependencies
in the remarks
he return value of ISDATE depends on the settings set by SET DATEFORMAT, SET LANGUAGE and default language option.
so you need to use
SET LANGUAGE us_english; SET DATEFORMAT mdy; /* Expression in mdy dateformat */ SELECT ISDATE('04/15/2008'); --Returns 1.
http://www.sambeauvois.be | @sambeauvois
None
0 Points
4 Posts
isDate() function in ASP.net (VB.net)
Jun 20, 2014 02:56 AM|maswood_silverlight|LINK
hi,
I have a localized website in English and Hebrew.
When I use the isDate() function in english it works fine.
When I use the isDate() function in hebrew it won't work fine.
The date passed in both scenarios is in the format "mm/dd/yyyy". E.g (10/25/2014)
Any help in this regard will be much appreciated.
isdate() localization asp.net
Contributor
3630 Points
776 Posts
Re: isDate() function in ASP.net (VB.net)
Jun 20, 2014 05:18 AM|sam_xiii|LINK
Hi
Check http://msdn.microsoft.com/en-us/library/ms187347%28SQL.105%29.aspx#SessionSettingDependencies
in the remarks
he return value of ISDATE depends on the settings set by SET DATEFORMAT, SET LANGUAGE and default language option.
so you need to use
SET LANGUAGE us_english; SET DATEFORMAT mdy; /* Expression in mdy dateformat */ SELECT ISDATE('04/15/2008'); --Returns 1.isdate() localization asp.net
http://www.sambeauvois.be | @sambeauvois