MSSQL:
@StartTime='2010-05-03 00:00:00.000';
@EndTime='2010-05-09 00:00:00.000';SET @StartEndTIME=CONVERT(VARCHAR(20),@StartTime,102)+'~'+CONVERT(VARCHAR(20),@EndTime,102);@StartEndTIME='2010.05.03~2010.05.09'pgsql:
convert(string using conversion_name)
使用指定的转换名字改变编码。转换可以通过 CREATE CONVERSION 定义。当然系统里有一些预定义的转换名字。
参阅 Table 9-7 获取可用的转换名。
convert('PostgreSQL' using iso_8859_1_to_utf8) UTF8 (Unicode, 8 位)编码的'PostgreSQL'PGSQL 中的CONVERT不和MSSQL一样的
求教!
解决方案 »
- 为什么 lock tables 不起作用 ?
- php中mysql_affected_rows()以及mysql_num_rows()对应mysql中的什么语句?
- 怎样把表的id字段的记录改为1,2,3。。。递增?
- 怎么在查询结果的后面增加一行“合计行”
- 谁知道好用一点的 mysql 的 profiler
- my sql连接
- [技巧] mysql 3.22以下版本不支持子查询, 但所有的子查询都可以使用LEFT JOIN 或 and语句替代
- msyql同一个数据库中三个数据表内数据合并问题,困扰我啊。。。。。
- 数据库数据加和 mysql
- 根据一个相同字段、时间提取另一表时间早于此时间最大的一条记录
- 如何insert 16进制数
- 带有分号的字段值,查询语句怎么写?
to_char(current_timestamp, 'HH12:MI:SS')Pattern Description
HH hour of day (01-12)
HH12 hour of day (01-12)
HH24 hour of day (00-23)
MI minute (00-59)
SS second (00-59)
MS millisecond (000-999)
US microsecond (000000-999999)
SSSS seconds past midnight (0-86399)
AM, am, PM or pm meridiem indicator (without periods)
A.M., a.m., P.M. or p.m. meridiem indicator (with periods)
Y,YYY year (4 and more digits) with comma
YYYY year (4 and more digits)
YYY last 3 digits of year
YY last 2 digits of year
Y last digit of year
IYYY ISO year (4 and more digits)
IYY last 3 digits of ISO year
IY last 2 digits of ISO year
I last digit of ISO year
BC, bc, AD or ad era indicator (without periods)
B.C., b.c., A.D. or a.d. era indicator (with periods)
MONTH full uppercase month name (blank-padded to 9 chars)
Month full capitalized month name (blank-padded to 9 chars)
month full lowercase month name (blank-padded to 9 chars)
MON abbreviated uppercase month name (3 chars in English, localized lengths vary)
Mon abbreviated capitalized month name (3 chars in English, localized lengths vary)
mon abbreviated lowercase month name (3 chars in English, localized lengths vary)
MM month number (01-12)
DAY full uppercase day name (blank-padded to 9 chars)
Day full capitalized day name (blank-padded to 9 chars)
day full lowercase day name (blank-padded to 9 chars)
DY abbreviated uppercase day name (3 chars in English, localized lengths vary)
Dy abbreviated capitalized day name (3 chars in English, localized lengths vary)
dy abbreviated lowercase day name (3 chars in English, localized lengths vary)
DDD day of year (001-366)
IDDD ISO day of year (001-371; day 1 of the year is Monday of the first ISO week.)
DD day of month (01-31)
D day of the week, Sunday(1) to Saturday(7)
ID ISO day of the week, Monday(1) to Sunday(7)
W week of month (1-5) (The first week starts on the first day of the month.)
WW week number of year (1-53) (The first week starts on the first day of the year.)
IW ISO week number of year (01 - 53; the first Thursday of the new year is in week 1.)
CC century (2 digits) (The twenty-first century starts on 2001-01-01.)
J Julian Day (days since November 24, 4714 BC at midnight)
Q quarter
RM month in uppercase Roman numerals (I-XII; I=January)
rm month in lowercase Roman numerals (i-xii; i=January)
TZ uppercase time-zone name
tz lowercase time-zone name
?column?
-----------------------
2010-05-09~2010-05-03
(1 row)
Table 9.20. Formatting FunctionsFunction Return Type Description Example
to_char(timestamp, text) text convert time stamp to string to_char(current_timestamp, 'HH12:MI:SS')
to_char(interval, text) text convert interval to string to_char(interval '15h 2m 12s', 'HH24:MI:SS')
to_char(int, text) text convert integer to string to_char(125, '999')
to_char(double precision, text) text convert real/double precision to string to_char(125.8::real, '999D9')
to_char(numeric, text) text convert numeric to string to_char(-125.8, '999D99S')
to_date(text, text) date convert string to date to_date('05 Dec 2000', 'DD Mon YYYY')
to_number(text, text) numeric convert string to numeric to_number('12,454.8-', '99G999D9S')
to_timestamp(text, text) timestamp with time zone convert string to time stamp to_timestamp('05 Dec 2000', 'DD Mon YYYY')
to_timestamp(double precision) timestamp with time zone convert Unix epoch to time stamp to_timestamp(1284352323)