Convert NVARCHAR column to DateTime - SQL Server

I need the datetime to be in the following format for SQL server 2005

dd/MM/YYYY HH:MI in 24 Hour Format

note: seconds are not included

Thanks for any help in advance

I have couple columns with "Apr 14 2004 12:00AM" nvarchar format in a table. I need to convert to "14-Apr-2004" nvarchar format. How can I do that? These are not in datetime format, and I have to get the 12:00am timing out of the column. There are many columns with many rows of data. Hope someone give me some idea, thanks!

Hi,

I'd like to have the date and time from server.

DateTime.Now Is ok?

Must be something else?

thanks.

Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.

Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.

George Shepherd

MSDN Magazine February 2004

George Shepherd

MSDN Magazine November 2003

What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.

Michael McManus

MSDN Magazine June 2000

Hello,

How do you write a date value to an XMLElement in .NET 3.5 XMLDocument object. 

 I am using the following:

DateTime orderDate = new DateTime();
orderDate = DateTime.Now; // 2010-08-24 16:45:46

string st = XmlConvert.ToString(orderDate, "yyyy-MM-dd");     // st="2010-08-24"
DateTime dt2 = XmlConvert.ToDateTime (st, "yyyy-MM-dd");   // dt2 = "2010-08-24 00:00:00"

I would like to remove the time section "00:00:00". I only need to write a date in the XML file with the following format :

<OrderDate>2010-08-24</OrderDate>

Order date is defined like this in the xsd file : <xs:element name="OrderDate" type="xs:date"/>

Thanks for your support.

Hi all,

i don't know nothing to ASP and i need your help to convert the following code to ASP.NET

set objHttp = Server.CreateObject("Microsoft.XMLHTTP") 
objHttp.open "POST", "https://api.c4sms.com/?" & strQueryString, false 
objHttp.setRequestHeader "Content-type", "application/x-www-form-urlencoded" 
objHttp.Send 

I need help for this.

Thank you very much.

If you known the full code is:

<% 
   Option Explicit 

   '**************** 
   'Replace values with your C4 username and password 
   CONST c4USERNAME = "Your C4 Username Here" 
   CONST c4PASSWORD = "Your C4 Password Here" 
   '**************** 
   Dim strReturnValue 

   'Function to send the SMS message 
   Function sendSMS(strSendToNumber,strMessage,strFromNumber) 

      'Create new variables 
      Dim strQueryString      'Holds data to post to C4 website 
      Dim objHttp            'The XMLHTTP object to make the post request 
      Dim strResponseTxt      'The response from the C4 server 

      'Build the query string 
      strQueryString = "username=" & c4USERNAME & "&password=" & c4PASSWORD & "&send