关于取日期的问题，帮忙看一下。

[临摹]

表中日期，是VARCHAR格式的。
2008-2-5
2008-2-3
2008-2-4
2008-2-7
2008-2-8
2008-2-9
2008-2-10
2008-2-11
2008-2-12
2008-2-13
我用SELECT MIN(DATESTAR) FROM TABLE时，取出的结果是2008-2-10。
怎么让取出的结果是2008-2-3。

[wzy_love_sly]

select min(cast(datestar as datetime)) from table

[青锋-SS]

select min(convert(char(10),datestar,120)) from table

[临摹]

楼上的好快，是我没说清楚，因为在修改程序时候使用的，最好取出后的字符
还是2008-2-3，不要把格式改变了，因为后面程序用到的都是这种格式。

[pt1314917]

要这样？

select   datename(yy,min(datestar))+'-'+ltrim(datepart(mm,min(datestar)))+'-'+ltrim(datepart(dd,min(datestar)))  from   table

[sdsxlj]

declare @t table(datestar varchar(100))      
insert into @t select '2008-2-5'             
insert into @t select '2008-2-3'             
insert into @t select '2008-2-4'             
insert into @t select '2008-2-7'             
insert into @t select '2008-2-8'             
insert into @t select '2008-2-9'             
insert into @t select '2008-2-10'            
insert into @t select '2008-2-11'            
insert into @t select '2008-2-12'            
insert into @t select '2008-2-13'            

select * from @t a where cast(a.datestar as datetime)=(select min(cast(datestar as datetime)) from @t b)

[sdsxlj]

datestar
----------------------------------------------------------------------------------------------------
2008-2-3

(1 行受影响)

[leo_lesley]

---例子 不知道是不是你要的
create table tb(datestar varchar(10))
insert tb
select '2008-2-5' 
union select '2008-2-3'
union select '2008-2-4' 
union select '2008-2-7' 
union select '2008-2-8' 
union select '2008-2-9' 
union select '2008-2-10' 
union select '2008-2-11' 
union select '2008-2-12' 
union select '2008-2-13' 


select top 1 datestar from tb order by year(datestar),month(datestar),day(datestar)


drop table tb

[wzy_love_sly]

declare @tb table (dt varchar(20))
insert into @tb select '2008-2-5'
insert into @tb select '2008-2-3'
insert into @tb select '2008-2-4'
insert into @tb select '2008-2-7'
insert into @tb select '2008-2-8'
insert into @tb select '2008-2-9'
insert into @tb select '2008-2-10'
insert into @tb select '2008-2-11'
insert into @tb select '2008-2-12'
insert into @tb select '2008-2-13'
select   convert(varchar(10),min(cast(dt   as   datetime)),120) as dt   from   @tb

2008-02-03

用convert转

[青锋-SS]

晕了

[青锋-SS]

declare @t table(datestar varchar(100))      
insert into @t select '2008-2-5'             
insert into @t select '2008-2-3'             
insert into @t select '2008-2-4'             
insert into @t select '2008-2-7'             
insert into @t select '2008-2-8'             
insert into @t select '2008-2-9'             
insert into @t select '2008-2-10'            
insert into @t select '2008-2-11'            
insert into @t select '2008-2-12'            
insert into @t select '2008-2-13'            

select * from @t a where cast(a.datestar as datetime)=(select min(cast(datestar as datetime)) from @t b)

datestar
----------------------------------------------------------------------------------------------------
2008-2-3

(1   行受影响) 

[yangjiexi]

declare @tb table(sdate varchar(10))
insert into @tb
select '2008-2-5'
union
select '2008-2-3'
union
select '2008-2-4'
union
select '2008-2-8'
union
select '2008-2-9'
union
select '2008-2-11'
union
select '2008-2-12'
union
select '2008-2-13'


select sdate from @tb
where cast(sdate as datetime)=(select min(cast(sdate as datetime)) from @tb)

[sdsxlj]

楼上抄的好快

[yangjiexi]

只不过是你发快了些!!这是一种思路!!

[sdsxlj]

发快了6分钟