oracle 从时间戳中提取年和月(6)

Extract year and month from timestamp(6)

提问by Martin Kóňa

I have database, where i have inserted timestamps(6) in this format : 18-AUG-14 02.49.27.000000000 PM.

我有数据库，其中i在这个格式插入时间戳（6）： 18-AUG-14 02.49.27.000000000 PM。

I want to extract it into this: 2014-08

我想把它提取成这个：2014-08

Its called ISO 8601

它被称为 ISO 8601

回答by Sathyajith Bhat

You'll need to use the to_charfunction to extract the year-month from timestamp.

您需要使用to_char函数从时间戳中提取年月。

select to_char(timestamp, 'yyyy-mm') from your_table

回答by iSaumya

I've done this in this way -

我是这样做的——

select extract(year from timestmp) || '-' || extract(month from timestmp) from texmp1;

Hope this helps.

希望这可以帮助。

Here is the table structure:

这是表结构：

    create table texmp1 
(
timestmp timestamp
);