Click here to Skip to main content
12,632,326 members (29,329 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: ASP.NET SQL
I want to store only current date in my database.
I use this
CREATE PROCEDURE dbo.UserRecord
AS
INSERT INTO tblDetail
(
   UNAME,
   UTYPE,
   CreatedDATE
)
VALUES
(
   @pUName,
   @pUType,
   getdate()
)
RETURN

it store date with time but i want to store date only.
Posted 22-Nov-12 4:37am
Updated 22-Nov-12 4:39am
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Another way is
convert(varchar(10), Getdate(), 101)

Reference - Answer to - Best way of store only date on datetime field?[^].

Thanks...
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

You can do this in a few ways. Here are one that I've used.
DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))
  Permalink  
Comments
pradiprenushe 23-Nov-12 1:36am
   
Very good logic. I was always having problem in this.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.161208.2 | Last Updated 22 Nov 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100