Re: hour of creation in table not correct



Hello,

The creation date will be always based on the date time on the SQL Server
machine.

Thanks
Hari

"Dan" <danperrt@xxxxxxxxx> wrote in message
news:uNvrBDagHHA.4032@xxxxxxxxxxxxxxxxxxxxxxx
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



.



Relevant Pages

  • Re: sql database creation and its ONLINE status
    ... SQL platform = MS SQL Server 2005 Express ... creation for its availabity? ... between db creation and its ONLINE status, if so, how much time? ... goto create ...
    (comp.databases.ms-sqlserver)
  • Re: Stored procedure modification date?
    ... No, SQL Server does not track this information, only creation date. ... Do you use source control? ... You could also instruct developers to always use DROP/CREATE. ...
    (microsoft.public.sqlserver.server)
  • Re: deployment of asp.net application
    ... Not sure since I have not automated the creation of IIS virtual ... directories and SQL Server DB creation through Inno. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Sp_ not scripted - corrupt syscomments?
    ... I created a new procedure in the query analzyer (sql server 8.0) ... It appeared to execute correctly on creation. ... @u_id int output ...
    (microsoft.public.inetserver.asp.db)
  • Re: How to force ANSI_NULLS ON for a user-defined function - AGAIN
    ... SQL server remebers the ANSI NULLS and QUOTEDIDENTIDFIER setting ... at the time of the creation of sps and function. ... > How can I configure a database so when I generate an SQL script for a UDF ...
    (microsoft.public.sqlserver.programming)