Browse by Tags

Home ›

All Tags » sql » date (RSS)

Null in ms sql date field

I have a date field in SQL that allows Null values. LastCheckedIn (allow null checked) On my web form, there's a TextBox called txtLastCheckedIn. I want the user to be able to leave it blank if the item has not been checked in before, in which case there should be a null in the DB. But the first...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by corbybender on 03-03-2009, 12:00 AM
Filed under: Null, sql, date
Insert Date Into SQL with Submission

Hello, When a user submits something via a form in my website, the info is sent and stored in an SQL Database. I would also like the date to be included to be displayed later (preferably in MM/DD/YYYY format). How do I do this? The page is ASP.NET VB. I need to know how to do this in Dreamweaver if it's...

Posted to Web Forms (Forum) by cvater on 02-03-2009, 12:00 AM
Filed under: sql, Submit., date
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
Re: trouble with insert query - date fields

Hi Jen, First, what is up with that single quote mark after @N? Did you want that to be enclosed in quotes because it's a string, or not? Also, when inserting dates into Access DBs you have to be careful with the formatting (yyyy-mm-dd vs dd-mm-yyyy) and ensure they are surronded with hash/number...

Posted to Access Databases and AccessDataSource Control (Forum) by djh on 03-10-2008, 12:00 AM
Filed under: SQL, insert, access database, date
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