SQL Server date format.

Nick Els

Thank you. I'm very new to this - I've a small program to start off with in which I'm adding records with 4 textboxes and a datapicker1 control on a Windows form. I'm not managing to get the SQL server databse to except my date format ie. "dd/mm/yyyy" - it insist I enter the date as YYYY-MM-DD

The databse is field for the date is set as DATE - I've tried adding a DEFAULT GETDATE() & also tried SYSTEM() for the field in design view, but to no avail.

CREATE TABLE [dbo].[PhoneIndex] (

[phoneId] INT IDENTITY (1, 1) NOT NULL,

[fName] VARCHAR (50) NOT NULL,

[lName] VARCHAR (50) NOT NULL,

[datePhoned] DATE NOT NULL DEFAULT GETDATE(),

[reaSon] VARCHAR (250) NOT NULL,

[PhoneNumber] NCHAR(15) NULL,

CONSTRAINT [PK_PhoneIndex] PRIMARY KEY CLUSTERED ([phoneId] ASC)

);

Source code attached ZIP file.

Thank you so much.

Nick.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel9y ago
Internal representation of the date in SQL server is a binary. So it doesn't really matter in what format you store the date. Instead you can store the date in appropriate format and for display purpose try converting it to required format.

https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql
Sundaram Subramanian9y ago
https://robbamforth.wordpress.com/2010/06/11/sql-date-formats-getdate-examples/

Try this link, this may helps you more, thanks in advance