while not adodataset1.Eof do
begin
for i:=0 to adodataset1.FieldCount-1 do
sheet.cells[row,i+1]:= adodataset1.Fields[i].AsString;
inc(row);
adodataset1.Next;
end;其中有一个日期型字段,输出到excel 后日期乱了!怎么办????
begin
for i:=0 to adodataset1.FieldCount-1 do
sheet.cells[row,i+1]:= adodataset1.Fields[i].AsString;
inc(row);
adodataset1.Next;
end;其中有一个日期型字段,输出到excel 后日期乱了!怎么办????
解决方案 »
- dspack怎么播放影片指定的区域?
- 问一个小问题,在线等,马上给分
- 一个数据库的问题
- 一个我想不通的问题,大家来讨论讨论
- MAPOBJECT的问题
- 哪位有魔力宝贝4.11版本的外挂啊?500分,其它分另开贴加(帮朋友找的)
- 一个存储过程的问题
- 请问delphi 7.0 用注册码安装后程序还是提示是个未注册的呢?
- 怎样将一个程序制作成服务程序,即在登录进系统之前就运行起来的服务程序!
- 哪位大大帮忙脱一下ASPack 2.12 -> Alexey Solodovnikov壳
- 怎样取得屏幕上任一个点的颜色值???(在线等待....................)
- delphi自带的vcl示范代码精典吗
begin
for i:=0 to adodataset1.FieldCount-1 do
begin
if adodataset1.Fields[i] is TDateTimeField then
sheet.cells[row,i+1]:= formatdatetime('yyyy-MM-dd',adodataset1.Fields[i].asdatetime)
else
sheet.cells[row,i+1]:= adodataset1.Fields[i].AsString;
inc(row);
adodataset1.Next;
end;
while not adodataset1.Eof do
Application.ProcessMessages;
begin
for i:=0 to adodataset1.FieldCount-1 do
Application.ProcessMessages;
sheet.cells[row,i+1]:= formatedatetime('yyyy-m-d',adodataset1.Fields[i].Asdatetime);
inc(row);
adodataset1.Next;
end;
while not adodataset1.Eof do
Application.ProcessMessages;
begin
for i:=0 to adodataset1.FieldCount-1 do
Application.ProcessMessages;
if ADOQuery1.Fields[i].DataType= ftdatetime then
sheet.cells[row,i+1]:= formatedatetime('yyyy-m-d',adodataset1.Fields[i].Asdatetime)
else
sheet.cells[row,i+1]:= adodataset1.Fields[i].Asstring;
inc(row);
adodataset1.Next;
end;
RETURNS VARCHAR(20)
AS
BEGIN
RETURN CAST( YEAR( @sourceDate ) AS VARCHAR(4) ) + '年' + CAST( MONTH( @sourceDate ) AS VARCHAR(2) ) + '月'+ CAST( DAY( @sourceDate ) AS VARCHAR(2) ) + '日'
END然后在查询时用以下语句实现:SELECT dbo.Date_To_Str( BirthDay ) AS TestDateTime FROM TestTable