How do I create current time and date in the following for sql query????

USE [UserLogin]
GO
/****** Object: Table [dbo].[AdminLog] Script Date: 11/05/2012 10:59:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AdminLog](
[Administrador] [varchar](50) NOT NULL,
[Actividad] [varchar](50) NOT NULL,
[Valor] [nchar](10) NOT NULL,
[Detalles] [varchar](50) NOT NULL,
[Hora] [datetime] NOT NULL,<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
[IP] [nchar](15) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF