首页 > 代码库 > PostgreSQL类型转换

PostgreSQL类型转换

2024-08-14 19:55:15   218人阅读

   1.int装string

   select CAST (1234 AS text)

 

select to_char(1234，’999‘)

 

2.string转int
 select cast(‘999‘ as NUMERIC)


--5 附: PostgreSQL 类型转换函数

 
FunctionReturn TypeDescriptionExample
 
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)
 
PostgreSQL类型转换






























        

            
                
                  
                
                

                    联系

                    我们