to_char function for 'timestamp' and 'datetime' type?!!
От | Jack Zhu |
---|---|
Тема | to_char function for 'timestamp' and 'datetime' type?!! |
Дата | |
Msg-id | 38F5FA3E.AD140DDA@netcom-sys.com обсуждение исходный текст |
Список | pgsql-admin |
Hi, all: PostgreSQL for Linux 6.5.3. Our app need to use 'to_char' function on one 'datetime' column, I use as following: 'select to_char(col_name,'MM/DD/YYYY HH:MI:SS') from tab_name where ...... ;' The error is 'No such function 'to_char' with the specified attributes.' Now I try the 'timestamp' type, 'cause our app has to show both date and time in one single columns. 'create table try (try timestamp);' createing is OK. 'insert into try values ('04/13/2000 00:00:00');' inserting is also Ok. 'select to_char(try, 'MM/DD/YYYY HH:MI:SS') from try;' Same error as above. 'select to_char(timestamp 'try', 'MM/DD/YYYY HH:MI:SS') from try;' the error is 'Bad abstime external representation 'try'. I have no idea what to do now! According to the docs, 'to_char' function should work on 'timestamp' data type. But I cannot make it work, Syntax error? The other thing, 'cause we cannot create index on 'timestamp' columns. We may have to stick with 'datetime' type. But how can we use 'to_char' function on 'datetime' data type? Could anyone help us out? Kind of emergency Thanks!!! Jack
В списке pgsql-admin по дате отправления: