Re: [SQL] time

2005-11-10 Thread Tadej Kanizar
So I don't open a new thread.. I have a table with a column of type TIMESTAMP. In output, I need to format it.. what's the best way to do it? So, for instance, how could I format it so that it would output as YY-MM-DD HH:MM? Regards, Tadej -Original Message- From: [EMAIL PROTECTED] [mail

[SQL] weird SQL statement question

2005-04-23 Thread Tadej Kanizar
Ok, so I installed the latest version of Postresql (8.02) on a WinXP SP2 machine.. My question is why won't the statement SELECT * FROM table work, whereas the statement SELECT * FROM »table« works! And, to explain a bit more, here's another example: INSERT INTO TestTable (Name, Surname