sdsf

来源：互联网发布：上海然旭网络怎么样编辑：程序博客网时间：2024/06/05 14:11

Timestamp representationCharacter conversion
TIMESTAMP(0) = '2003-12-07 11:37:58'                         CHAR(19)
TIMESTAMP(6) = '2003-12-07 11:37:58.213000'          CHAR(26)

SEL CURRENT_TIMESTAMP ;

            Current TimeStamp(6)
--------------------------------
2014-05-24 12:19:52.460000+00:00

// 366 02

SELECT (TIMESTAMP '2004-10-20 10:25:40' - TIMESTAMP '2003-10-20 08:25:40') DAY( 3) TO HOUR;

// 05/10/01

SELECT CAST (TIMESTAMP '2005-10-01 09:30:22' AS DATE) ;

/**They overlap **/
SELECT 'They overlap' WHERE
(DATE '2004-01-01', DATE '2004-11-30') OVERLAPS
(DATE '2004-10-15', DATE '2004-12-31') ;

/** No row returned **/
SELECT 'They overlap' WHERE
(DATE  '2003-01-01', DATE '2003-10-15') OVERLAPS
(DATE  '2003-10-15', DATE '2003-12-31') ;

/** 2014-May-24 **/
SELECT CURRENT_DATE ( FORMAT 'Y4-M3-DD' );

/** 2013-Dec-31 **/
SELECT DATE '2013-12-31' ( FORMAT 'yyyy-mmm-dd' ) ;

/** 2014-05-24 **/
SELECT CURRENT_DATE ( FORMAT 'YYYY-MM-DD' );


/**  04:51:10 **/
SELECT CURRENT_TIME ( FORMAT 'HH:MI:SS' );

/**  04:51:24-08:00 **/
SELECT CURRENT_TIME ;

0 0