Q: I have a query INSERT INTO ...SELECT FROM ...
were in select statement I have this sintax: convert(varchar(10),ColName,103)
for convert date type "DD/MM/YYYY HH.MM.SS" to format: "DD/MM/YYYY"
when try to execute in QueryAnalyzer, it show this error:
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
A: SET DATEFORMAT DMY
Subscribe to:
Post Comments (Atom)
Blog Archive
- 
        ▼ 
      
2007
(52)
- 
        ▼ 
      
October
(30)
- Serp Archive
 - Internet names for Asia launched
 - MS SQL server: How to dynamically number rows in ...
 - MS SQL server: E-mail address validation
 - MS SQL server: How can I do a case-sensitive comp...
 - MS SQL server: How to troubleshoot orphan users i...
 - Eric Enge Interviews Google's Matt Cutts
 - Goo.glicio.us - No more PageRank updates, Hello Pa...
 - Corel Draw / Photo Paint Palette Generator
 - VBScript: Capitalize String Function
 - VBScript: URLDecode Function
 - VBScript: URLEncode Function
 - MS SQL server: Checking if a temporary table exists
 - SQL Server: conversion from char to date error
 - JavaScript: Doctype messing up script
 - MS SQL server: Split up a string
 - Connect to a .csv file via stored procedure in MS ...
 - MS SQL server: How can I use the result set from ...
 - MS SQL server: database marked as "suspect"
 - MS SQL Future Keywords
 - ODBC Reserved Keywords
 - MS SQL Reserved keywords
 - Optimizing SQL Server CPU Performance
 - Scientists Invent 30 Year Continuous Power Laptop ...
 - Report: Russia Evacuates Entire Bushehr Staff
 - Welcome To The DMOZ Blog
 - The most popular sites for domain names
 - Google, Yahoo Sued For Stealing Names From Tanzani...
 - CSS Layouts
 - CSS Three Column Liquid Layout with Header and Footer
 
 
 - 
        ▼ 
      
October
(30)
 
No comments:
Post a Comment