On Sat, Jan 03, 2004 at 10:20:57PM +0100, ivan wrote:
ok, bat each time where i want to do select .. a nie tu use to_char,
but it should be in function timestamp_out to convert time to string
it would be easer and faster.
I don't think it will too much faster :-)
BTW, for example the
there can be same problems with back convering, but its would be only
when select is going out, to cstring form, and all its depend on user,
but this is ok :)
On Mon, 5 Jan 2004, Karel Zak wrote:
On Sat, Jan 03, 2004 at 10:20:57PM +0100, ivan wrote:
ok, bat each time where i want to do
El Sáb 03 Ene 2004 18:20, ivan escribió:
ok, bat each time where i want to do select .. a nie tu use to_char,
but it should be in function timestamp_out to convert time to string
it would be easer and faster.
Look deeper into what Christopher said and use casting to get the right
output:
Martin Marques [EMAIL PROTECTED] writes:
Look deeper into what Christopher said and use casting to get the right
output:
prueba= select now()::timestamp(0);
There's also current_timestamp(0), which is a more standards-compliant
way of doing the same thing.
regards,
i know, but i talking about default time output, it would be for
time, date and date with time, not formating all the time.
On Sun, 4 Jan 2004, Tom Lane wrote:
Martin Marques [EMAIL PROTECTED] writes:
Look deeper into what Christopher said and use casting to get the right
output:
prueba=
Quoting Tom Lane [EMAIL PROTECTED]:
Martin Marques [EMAIL PROTECTED] writes:
Look deeper into what Christopher said and use casting to get the right
output:
prueba= select now()::timestamp(0);
There's also current_timestamp(0), which is a more standards-compliant
way of doing the same
but what about default style ?
first time when i saw DateStyle i thought that i can use it like C/C++
function strftime. I would be not bad idea to have custom data style :)
On Fri, 2 Jan 2004, Christopher Kings-Lynne wrote:
Create table with type TIMESTAMP(0)
Chris
ivan wrote:
how
On Sat, Jan 03, 2004 at 09:25:14AM +0100, ivan wrote:
but what about default style ?
first time when i saw DateStyle i thought that i can use it like C/C++
function strftime. I would be not bad idea to have custom data style :)
Use to_char() function to put it in any format you want.
Kurt
ok, bat each time where i want to do select .. a nie tu use to_char,
but it should be in function timestamp_out to convert time to string
it would be easer and faster.
On Sat, 3 Jan 2004, Kurt Roeckx wrote:
On Sat, Jan 03, 2004 at 09:25:14AM +0100, ivan wrote:
but what about default style
Create table with type TIMESTAMP(0)
Chris
ivan wrote:
how can i change default time format because now i have for example
2004-01-01 16:51:46.995927 but i want only 2004-01-01 16:51:46, with out
millisec. a tryed with Data-Style but there arent custom style :/
---(end
how can i change default time format because now i have for example
2004-01-01 16:51:46.995927 but i want only 2004-01-01 16:51:46, with out
millisec. a tryed with Data-Style but there arent custom style :/
---(end of broadcast)---
TIP 6: Have
11 matches
Mail list logo