ÔÚSQLÖÐʹÓÃconvertº¯Êý½øÐÐÈÕÆÚµÄ²éѯ
Ôø¾Óöµ½ÕâÑùµÄÇé¿ö,ÔÚÊý¾Ý¿âµÄMeeting±íÖÐÓÐPublishTime (DateTime,8)×Ö¶Î,ÓÃÀ´´æ´¢Ò»¸ö¿ª»áʱ¼ä,ÔÚ´æÈëʱÓÉÓÚÒªÖ¸Ã÷¿ª»á¾ßÌåʱ¼ä,¹Ê¸ñʽΪyyyy-mm-dd hh:mm:ss,¶øÎÒÃDzéѯʱÊÇͨ¹ýyyyy-mm-ddÀ´½øÐеÄ,¼´²éѯijһÌìµÄËùÓлáÒéÐÅÏ¢,ÕâÑùÈç¹ûͨ¹ýselect * from Meeting where PublishTime=@PublishTime (²ÎÊý@PublishTimeΪyyyy-mm-dd¸ñʽ)Óï¾ä½øÐвéѯ½«ÎÞ·¨µÃµ½ÕýÈ·½á¹û,±ÈÈçÎÒÃÇÒª²éѯ2004Äê12ÔÂ1ÈյĻáÒéÐÅÏ¢,ÔÚÊäÈë2004-12-01ʱ¾Í²»Äܵõ½²éѯ½á¹û,¶øÕâÖÖ²éѯÓÖ²»ÄÜÒªÇóÊäÈë¾ßÌåµÄhh:mm:ss.
¡¡¡¡´ËʱÎÒÃÇÐèҪʹÓÃconvertº¯Êý,Ëü¿ÉÒÔ½«Ò»ÖÖÊý¾ÝÀàÐ͵ıí´ïʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐ͵ıí´ïʽ.´Ë´¦ÎÒÃÇÏȽ«Êý¾Ý¿âÄÚµÄdatetimeÀàÐÍת»»ÎªcharÀàÐÍ,ÓÉÓÚÊäÈëµÄ²ÎÊýÊÇ10λµÄ,ËùÒÔд³É
¡¡¡¡select * from Meeting where convert(varchar(10),PublishTime,121))=@PublishTime,ÕâÑùÔÚ²éѯʱÊý¾Ý¿âµÃµ½²ÎÊýºóÏÈ×Ô¶¯½«Êý¾Ý¿âÄÚµÄÐÅϢת»»Îªyyyy-mm-dd¸ñʽµÄ10λ×Ö·û,Ö»ÒªÓë²ÎÊýÏàͬ¼´¿É·µ»Ø²éѯ½á¹û.¶øconvertÖеÄ121ÊÇÖ¸½«datetimeÀàÐÍת»»ÎªcharÀàÐÍʱ»ñµÃ°üÀ¨ÊÀ¼ÍλÊýµÄ4λÄê·Ý
¡¡¡¡ÒÔÉÏÊÇÎÒÔÚ¿ª·¢ÖÐÓöµ½µÄСÀ§ÄѵÄ×ܽá,Èç¹ûдµÄÓв»ÕýÈ·µÄµØ·½»¶Ó´ó¼ÒÖ¸½Ì!
Ïà¹ØÎĵµ£º
1. ²é¿´Êý¾Ý¿âµÄ°æ±¾
select @@version
³£¼ûµÄ¼¸ÖÖSQL SERVER´ò²¹¶¡ºóµÄ°æ±¾ºÅ:
8.00.194 Microsoft SQL Server 2000
8.00.384 Microsoft SQL Server 2000 SP1
8.00.532 Microsoft SQL Server 2000 SP2
8.00.760 &nb ......
1. ʹÓõÄÊÇ·þÎñÆ÷Éϵ쬲»ÊDZ¾»úµÄOracle£¬°´ÏÂÃæ×ö¾Í¿ÉÒÔÁË£º
ÉèÖû·¾³±äÁ¿:NLS_LANG£¬¾ßÌåÖµÓÃÏÂÃæ²éѯµÄÖµ:
SELECT 'AMERICAN_AMERICA.' || PROPERTY_VALUE
from DATABASE_PROPERTIES
WHERE PROPERTY_NAME = 'NLS_CHARACTERSET';
2. Èç¹ûÊDZ¾»úµÄOracle¾ÍÐèÒªÔÚOracleµÄ°²×°Ä¿Â¼ÏÂÃæ¸ÄÉèÖãº
......
³õ¼¶Æª —— ¼òµ¥²éѯÓï¾äµÄµ÷ÓÅ ÀîÃ÷»Û , Èí¼þ¹¤³Ìʦ, IBM
ÀîÃ÷»Û£¬ÔÚ IBM ÖйúÈí¼þ¿ª·¢ÖÐÐÄ Data Studio ÍŶӹ¤×÷´ÓÊ InfoSphere Warehouse Administration Console µÄ¹¦ÄܲâÊÔ¹¤×÷¡£ÔøÔÚ developerWorks ·¢±í¡¶½« DB2 DWE 9.1.X Ç¨ÒÆµ½ DB2 Warehouse 9.5¡·¡¢¡¶InfoSphere Warehouse SQL ²Ö´¢ÃüÁîÐнӿ ......
--1. ´´½¨±í£¬Ìí¼Ó²âÊÔÊý¾Ý
CREATE TABLE tb(id int, [value] varchar(10))
INSERT tb SELECT 1, 'aa'
UNION ALL SELECT 1, 'bb'
UNION ALL SELECT 2, 'aaa'
UNION ALL SELECT 2, 'bbb'
UNION ALL SELECT 2, 'ccc'
--SELECT * from tb
/**//*
id value
----------- ----------
1 aa
1 bb
2 aaa
......
ÄãµÄSQL Server 2000±ØÐë´òÉÏSP3µÄ²¹,È»ºó°²×°MicrosoftµÄJDBCÇý¶¯,½«ÒÔÏÂÈý¸öjar°ü¸´ÖƵ½WebContent\WEB-INF\lib
msbase.jar
mssqlserver.jar
msutil.jar
ÏÂÃæÊDzâÊÔ´úÂ룬ûÓб¨´íÊý¾Ý¿â¾ÍÄÜÕý³£Á¬½Ó
public class DbcTest {
/**
* @param args
*/
public static void main(String[] args) {
Str ......