Browse by Tags

Home ›

All Tags » sql » datetime (RSS)

insert columns but get error about null datetime field

Hi there, I am doing an INSERT into a table. I have a "DateCreated" field and I have set the field to ALLOW NULLS = FALSE but set the default value to getdate() When I execute the stored procedure it tell me "SqlException: Cannot insert the value NULL into column "DateCreated"...

Posted to Data Access and ObjectDataSource Control (Forum) by mongoose_za on 06-11-2009, 12:00 AM
Filed under: null, SQL, stored procedure, datetime
How can I store an NT FileTime in a SQL table?

I've got datetimes stored in NT FileTimes and I need to insert them into a SQL table. Initially, I thought I could just use a SQL datetime but my test pack shows me I can't. SQL datetimes, it seems, can only store values "between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" whereas...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ssg31415926 on 11-30-2008, 12:00 AM
Filed under: SQL, datetime, FileTime
Date format mismatch (Calendar - SQL)

Hi folks. In my newest project I have to make use of the ASP calendar control along with the ussual data controls like GridViews etc. It works like this... The user will select a day on the calendar The gridview will check a database for any entries with that date and return them on screen The user also...

Posted to Web Forms (Forum) by RyanMD on 08-12-2008, 12:00 AM
Filed under: sql, datetime, GridView
Problem with Display Date or any Data in Textbox having Masked Edit Extender

Hello, I have a web page in C# , in which I have a text box and the masked edit extender. So i will enter the date and click save it in the database in the form of (mm/dd/yyyy). So the Main problem is when i fetch the date from the database and store it in the text box, it is not storing, that is, no...

Posted to ASP.NET AJAX Control Toolkit (Forum) by Sudheendra B on 06-27-2008, 12:00 AM
Filed under: sql, sql datetime compare, TextBox, VS 2005 Web Site Project, Web Controls, ADO.NET 2.0, ajax, ajax extensions, ajaxtoolkit, asp .net 2.0, ASP .NET 1.1, asp .net 2.0, ASP.NET, asp.net 2.0 c#, ASP.Net C#, asp.net 2, ASP.NET C#, Atlas, c#, c# 1.1, c#.net, calendar control, date, datetime, datetime.tostring(), webform, Asp.net2.0, asp.net2.0 using c#, ASP .net2.0, VS2005, ajax control toolkit, .ascx .aspx C#, .aspx page, .cs, asp .net ... c# ... SQL, asp .net 1.1 web form controls, ASP .net 2 .0 DATABASE APPLICATION, asp.net ajax Toolkit, date order, Date Query & Result, Date Textbox, date validate, .Net 2.0, ASP .net 2.0 C#, asp.net 2.0 C#, ASP.NET web form, SQL SELECT
DateTime confusion.

Hi All, I'm stumped. I've got a stored procedure with a number of input parameters, and working fine. I added two extra input parameters, FromDate datetime, ToDate datetime. I have not even included these in the SQL yet and just tried to execute the stored proc alone with manually inputting paramters...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by dotdodont on 10-25-2007, 12:00 AM
Filed under: SQL, conversion, convert, datetime, stored procedure, date