asp.net - date - date format changes in server

Question

I have a code in asp.net, where the user enters the date selection throught an AJAX calendar pop-up control as per below:

<td class="style14">
<asp:TextBox ID="DateSelection" runat="server" Height="22px" Width="90px"
AutoPostBack="True"></asp:TextBox>
<asp:ImageButton ID="ImageButtonDateSelection" runat="server" Height="22px" 
ImageUrl="~/Images/Calendar.jpg" Width="19px" />
<asp:CalendarExtender ID="CalendarExtenderDateSelection" runat="server" 
Format="dd/MM/yyyy" PopupButtonID="ImageButtonDateSelection" 
PopupPosition="BottomRight" TargetControlID="DateSelection" 
FirstDayOfWeek="Monday">
</asp:CalendarExtender></td>

From SQL I pickup the date and use it in the SQL code as follows:

declare @dt datetime 
set @dt = convert(datetime,'" & DateSelection.Text & "',104

All is well in my remote desktop, but when I publish the site it doent' work due to diferent date formats on server.

I can not figure out what format the server has, but I'm wondering if there is a fool proof way to work with any date format, so that I can develop on my pc with my date format and send the code safely to the server and warantee that it will work. Thanks.

peterm · Accepted Answer · 2013-03-09 17:27:33Z

1

First of all you can check what is the dateformat setting for your connecdtion on that server by DBCC USEROPTIONS

DBCC USEROPTIONS

Output:

Set Option  Value
----------------------
...
language    us_english
dateformat  mdy         <---
datefirst   7
...

Second you can change date format for your connection using SET DATEFORMAT

SET DATEFORMAT MDY;

Third and you can always use SQL/ISO date format which is YYYY-MM-DD

DECLARE @dt DATETIME 
SET @dt = CONVERT(DATETIME,'2013-03-09')

edited Mar 9, 2013 at 17:27

answered Mar 9, 2013 at 17:14

peterm

93k16 gold badges157 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Raghubar · Accepted Answer · 2013-03-09 17:00:18Z

0

Set the culture property as : - <%@ Page Title="" Language="C#" MasterPageFile="~/User/MainMaster.master" AutoEventWireup="true" CodeFile="MemberRegistration.aspx.cs" Inherits="HO_MemberRegistration" Culture="en-gb" %>

answered Mar 9, 2013 at 17:00

Raghubar

2,7981 gold badge23 silver badges31 bronze badges

Collectives™ on Stack Overflow

asp.net - date - date format changes in server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related