ASP.NET

how to get system date RSS

13 replies

Last post Dec 23, 2012 11:36 PM by Dan Bracuk

‹ Previous Thread|Next Thread ›

- Reply
dn631

Member

6 Points

39 Posts

how to get system date

Dec 22, 2012 10:37 AM|LINK

how to get system date...to every new(next ) row created in sql table....Time is not required only date is required
- Moved by mbanavige on Dec 23, 2012 03:19 PM
- Reply
urenjoy

Star

12347 Points

1857 Posts

Re: how to get system date

Dec 22, 2012 10:55 AM|LINK

You can set Default value = GetDate() in properties of column.

You can do it in SQL also, check following

http://stackoverflow.com/questions/4672103/default-getdate-for-insert-date

http://techbrij.com
- Edited by urenjoy on Dec 22, 2012 11:02 AM
- Reply
KiaranNafade

Member

134 Points

58 Posts

Re: how to get system date

Dec 22, 2012 10:56 AM|LINK

use getdate(); function

e.g.

insert into table (col1.col2,coldate) values(valu1,val2,getdate())

Plz,..plz.... Click "Mark A Answer" if helps for you
- Reply
oned_gk

All-Star

31661 Points

6473 Posts

Re: how to get system date

Dec 22, 2012 10:58 AM|LINK
try : DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

Programming to simplify, dont look for hard way
- Reply
dn631

Member

6 Points

39 Posts

Re: how to get system date

Dec 22, 2012 11:00 AM|LINK

in what coloumn property shhould we place this getdate( ) function...
- Edited by dn631 on Dec 22, 2012 11:01 AM
- Edited by dn631 on Dec 22, 2012 11:02 AM
- Reply
Anil Srivast...

Member

442 Points

292 Posts

Re: how to get system date

Dec 22, 2012 11:01 AM|LINK

This is just Database Design

insert system date will from front end(C#/vb)

see the following link

http://forums.asp.net/t/982733.aspx/1

http://www.dotnetspider.com/forum/313523-How-insert-with-system-date.aspx
- Reply
oned_gk

All-Star

31661 Points

6473 Posts

Re: how to get system date

Dec 22, 2012 11:11 AM|LINK
you can set DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) as default value your field or to your INSERT command

Programming to simplify, dont look for hard way
- Reply
dn631

Member

6 Points

39 Posts

Re: how to get system date

Dec 22, 2012 11:13 AM|LINK

oned_gk can you come to gtalk
- Edited by dn631 on Dec 22, 2012 11:13 AM
- Reply
dn631

Member

6 Points

39 Posts

Re: how to get system date

Dec 22, 2012 11:30 AM|LINK

this is what i did

http://i49.tinypic.com/3359r4n.png
- Edited by dn631 on Dec 22, 2012 11:34 AM
- Edited by dn631 on Dec 22, 2012 11:35 AM
- Reply
oned_gk

All-Star

31661 Points

6473 Posts

Re: how to get system date

Dec 22, 2012 11:38 AM|LINK
use smalldatetime type and set default value or binding. You will get the value with 00:00:00

Programming to simplify, dont look for hard way
- Edited by oned_gk on Dec 22, 2012 11:41 AM