title: ASP.NET / SQL Server - Set Time Zone
body: <p>We have an ASP.NET website and an SQL database hosted in US. Whenever I use the function <code>Now()</code> in VB.NET and <code>getdate()</code> in SQL, I get the US' current time. The problem is, the client is in the Philippines which is on GMT+8 Time Zone. My question is, is there any way I can set the Time Zone of a specific database and website so that when I use the functions, I'll get the  Philippine's current time? How do you deal with this? As much as possible, we don't want to do subtraction or addition to the result date of the functions since in the future, clients will be from other country. It will give us headache updating the codes if we do that.</p>
  
  <p>Thank you in advance!</p>