BizTalk Utilities CV ,   Jobs ,   Code library
 
Home Page


Add/Edit your code items
Search the code library
Browse for the code library

SQL XML

SQL XML

SQL XML Contents

Filtering unique values
Passing stored procedure a list of complete zipcodes to validate
Convert a flat text file into xml
XML IMDB Concepts.
Using XML as a Data Store
Creating An XML Based Cache Using COM
Character encoding, a few words on the subject
How to use the ADO Stream object to retrieve SQL2000 XML
How to transfer XML into a plain text file?
Convert XDR to XML
Sort a table using the header of the table
Applying a XSLT stylesheet using the DBMS_XMLQuery package
N:N relationships with DBMS_XMLQuery Package
DBMS_XMLQuery package bind values to produce more than one xml file
Download data from a database in XML
Inserting XML file into a table using DBMS_XMLSave Package
Insert XML file into a table using ADO
How to call out to a COM component's method through XSLT
How to select DISTINCT items from XML via XSLT
How to convert Word (RTF) documents to XML for auto publication
 
 

<< SEOSystem.XML >>

By Daraesh Mistry
First Posted 03/26/2001
Times viewed 420

Converting to DateTime format in SQL

Summary Converting a date stored in varchar format in SQL Server to a datetime format field.

As datetime formats are picked up from the regional settings of your machine/server it is sometimes difficult to store a user customized date in the table. Rather we end up storing the datetime in the varchar format provided by your RDBMS. Lets say we store the date in DD/MM/YYYY format in varchar. But while comparing dates we need to convert the date from varchar to the datetime format provided by the RDBMS. The following code snippet converts the date into MM/DD/YY format for date manipulation. It displays all records that have been ordered between 1st March, 2001 and 8th March, 2001

Additional information

Further additional information

Rate this article on a scale of 1 to 10 (0 votes, average 0)

Your vote :  

<< SEOSystem.XML >>



Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown:

 
 

    Email TopXML