hour of creation in table not correct

From: "Dan" <danperrt@xxxxxxxxx>
Date: Wed, 18 Apr 2007 12:03:15 +0200

Hi,

when i create a new user in a .MDF file, the hour of creation in the field
"createdate" of table "membership" is exactly 2 hours less than the time of
my computer. Probably something to do with different hours between Europe
and UK or ...

How can i set the creation hour to exact the same hour of my computer?

Thanks
Dan

.

Follow-Ups:
- Re: hour of creation in table not correct
  - From: Hari Prasad

Prev by Date: How do you capture SQL Express 2005 installation errors?
Next by Date: why two fields "email" and "lowered email" in table aspnet_memebership?
Previous by thread: How do you capture SQL Express 2005 installation errors?
Next by thread: Re: hour of creation in table not correct
Index(es):
- Date
- Thread

Relevant Pages

Re: hour of creation in table not correct
... The creation date will be always based on the date time on the SQL Server ... when i create a new user in a .MDF file, the hour of creation in the field ... How can i set the creation hour to exact the same hour of my computer? ...
(microsoft.public.sqlserver.setup)
Re: Is there a way to determine if a software has been installed via RDP?
... You could try to establish the exact date the software was installed ... (usually the creation date of the application's main folder), ... MCSE, CCEA, Microsoft MVP - Terminal Server ... TS troubleshooting: http://ts.veranoest.net ...
(microsoft.public.windows.terminal_services)
Re: Whack jobs disproving themselves (Re: Seal Controversy: From Temech to Shlomit)
... SolomonW wrote: ... biblically-based view & call it science? ... "creation" before employing the exact same biblically ...
(soc.history.ancient)
Re: Whack jobs disproving themselves (Re: Seal Controversy: From Temech to Shlomit)
... "creation" before employing the exact same biblically ... If you ask me do I believe in creationist science then the answer is no. ... If you ask me do I believe that there is real history in the bible the ...
(soc.history.ancient)
Re: hour of creation in table not correct
... of the internal clock of my computer? ... The creation date will be always based on the date time on the SQL Server ... How can i set the creation hour to exact the same hour of my computer? ...
(microsoft.public.sqlserver.setup)