Date time

[bbawa1]

Hi,

I have a table in sql server of datatype datetime. I want to set it's
default value to Current date in design mode. I am typing in default
value property = Date.now(). But it doesn't work. Any idea.

Thanks

[Alexey Smirnov]

On May 24, 11:45 pm, [e-mail] wrote:

Hi,

I have a table in sql server of datatype datetime. I want to set it's
default value to Current date in design mode. I am typing in default
value property = Date.now(). But it doesn't work. Any idea.

Thanks

Where do you type it?

SQL Server has built-in function getdate(), which is the same as
DateTime.Now from .NET

[bbawa1]

On May 24, 3:07 pm, Alexey Smirnov <[e-mail]:

On May 24, 11:45 pm, [e-mail] wrote:

Hi,

I have a table in sql server of datatype datetime. I want to set it's
default value to Current date in design mode. I am typing in default
value property = Date.now(). But it doesn't work. Any idea.

Thanks

Where do you type it?

SQL Server has built-in function getdate(), which is the same as
DateTime.Now from .NET

I am typing this in Design mode of table. I highlight the column and
then there is column proerties. "Default value or Binding". I am
typing this over here.

[Alexey Smirnov]

On May 25, 12:11 am, [e-mail] wrote:

On May 24, 3:07 pm, Alexey Smirnov <[e-mail]:

On May 24, 11:45 pm, [e-mail] wrote:

Hi,

I have a table in sql server of datatype datetime. I want to set it's
default value to Current date in design mode. I am typing in default
value property = Date.now(). But it doesn't work. Any idea.

Thanks

Where do you type it?

SQL Server has built-in function getdate(), which is the same as
DateTime.Now from .NET

I am typing this in Design mode of table. I highlight the column and
then there is column proerties. "Default value or Binding". I am
typing this over here.

Use getdate()

http://msdn2.microsoft.com/en-us/library/ms188383.aspx

[bbawa1]

On May 24, 3:22 pm, Alexey Smirnov <[e-mail]:

On May 25, 12:11 am, [e-mail] wrote:

On May 24, 3:07 pm, Alexey Smirnov <[e-mail]:

On May 24, 11:45 pm, [e-mail] wrote:

Hi,

I have a table in sql server of datatype datetime. I want to set it's
default value to Current date in design mode. I am typing in default
value property = Date.now(). But it doesn't work. Any idea.

Thanks

Where do you type it?

SQL Server has built-in function getdate(), which is the same as
DateTime.Now from .NET

I am typing this in Design mode of table. I highlight the column and
then there is column proerties. "Default value or Binding". I am
typing this over here.

Use getdate()

http://msdn2.microsoft.com/en-us/library/ms188383.aspx- Hide quoted text -

- Show quoted text -

Thanks a lot . It solved my problem.