complexity in saving date from different countries
-
Hi all, I have deployed one application on server reside in US,now problem is that when any person using this site from india and he save some data in current date but my application is deployed on US Server so it takes system date of that server which is about one day b4 in some cases and when user search that data in this date he could not get it,is there any way to remove this complexity N!dh! :)
-
Hi all, I have deployed one application on server reside in US,now problem is that when any person using this site from india and he save some data in current date but my application is deployed on US Server so it takes system date of that server which is about one day b4 in some cases and when user search that data in this date he could not get it,is there any way to remove this complexity N!dh! :)
Hi Nidhi, One probable solution for this is to change the default value of date column from **GetDate()**to GetUTCDate() in table defination. This way it will store the date values according to UTC instead of local time zone specific date.
dnpro "Very bad programmer"
-
Hi Nidhi, One probable solution for this is to change the default value of date column from **GetDate()**to GetUTCDate() in table defination. This way it will store the date values according to UTC instead of local time zone specific date.
dnpro "Very bad programmer"
-
Hi, I have deployed my all code and it is difficult to change this thing on whole application.Perhaps there is any way using globalization element in web.config. N!dh! :)
I guess you can change it on database table's column definition. There is no code change require for this. :)
dnpro "Very bad programmer"
-
I guess you can change it on database table's column definition. There is no code change require for this. :)
dnpro "Very bad programmer"