db2字符串转date_DB2中时间型字段的转换

I want to convert a Date column to a formatted string in DB2. This SQL works fine:

select varchar_format(current timestamp, 'YYYY-MM')

from sysibm.sysdummy1;

but this SQL gives an error:

select varchar_format(current date, 'YYYY-MM')

from sysibm.sysdummy1;

The error is: [SQL0171] Argument 1 of function VARCHAR_FORMAT not valid.

In the first SQL, the first arg for VARCHAR_FORMAT is a timestamp, and that works. In the second SQL, the first arg for VARCHAR_FORMAT is a date, and that doesn't work.

The IBM doc implies that there's only this one function, VARCHAR_FORMAT (and its synonym, TO_CHAR).

How am I supposed to convert a DATE (not a TIMESTAMP) to a string? Or, do I have to convert the DATE to a TIMESTAMP first, then use VARCHAR_FORMAT?

I am running DB2 7.1 for i Series.

Update: converting to TIMESTAMP_ISO works. But it's ugly:

select varchar_format(timestamp_iso(current date), 'YYYY-MM')

from sysibm.sysdummy1;

That one works.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值