gt; Postgres stores timestamps as a numbers. Its power is reliable
> conversion to client time zone (or between time zones). "timestamp
> with time zone" is actually duration since epoch (UTC) and conversion
> to a time zone on select.
>
> However storing local time might be
ow nothing concerning the datetime type in Oracle.
Postgres stores timestamps as a numbers. Its power is reliable
conversion to client time zone (or between time zones). "timestamp with
time zone" is actually duration since epoch (UTC) and conversion to a
time zone on select.
However
On Thu, Dec 07, 2023 at 10:18:44PM -0600, Nicholas Geovanis wrote:
[...]
> All of these considerations are what brought Oracle to create a proprietary
> "datetime" datatype and use it to store all "real" dates/times. If you need
> a different format for display purposes or a human readable column
On Fri, Dec 08, 2023 at 09:11:12AM +0700, Max Nikulin wrote:
> On 07/12/2023 23:08, tomas wrote:
> > On Thu, Dec 07, 2023 at 10:29:29PM +0700, Max Nikulin wrote:
> > > On 07/12/2023 21:22, John Hasler wrote:
> > > > Databases should never store local time.
> >
On Thu, Dec 7, 2023, 8:11 PM Max Nikulin wrote:
> On 07/12/2023 23:08, tomas wrote:
> > On Thu, Dec 07, 2023 at 10:29:29PM +0700, Max Nikulin wrote:
> >> On 07/12/2023 21:22, John Hasler wrote:
> >>> Databases should never store local time.
> >>
> >&g
On 07/12/2023 23:08, tomas wrote:
On Thu, Dec 07, 2023 at 10:29:29PM +0700, Max Nikulin wrote:
On 07/12/2023 21:22, John Hasler wrote:
Databases should never store local time.
There are exceptions when storing UTC instead of local time leads to
undesired consequences.
Heh. There was one
On Thu, Dec 07, 2023 at 10:29:29PM +0700, Max Nikulin wrote:
> On 07/12/2023 21:22, John Hasler wrote:
> > Databases should never store local time.
>
> I am anticipating a new branch of hot discussion.
>
> There are exceptions when storing UTC instead of local time
On 07/12/2023 21:22, John Hasler wrote:
Databases should never store local time.
I am anticipating a new branch of hot discussion.
There are exceptions when storing UTC instead of local time leads to
undesired consequences.
Planned (future) events may be bound namely to local time. So if
hat works if the file doesn't exist.
>
>> I just want to set the hardware clock to local time since this machine
>> is shared with Windows and the clock is actually local time.
>
> You might consider telling Windows to use UTC as well. For example here:
> https://feldsp
CC'ing back to the list.
On Fri, Feb 11, 2022 at 03:34:35PM +0100, José Luis González wrote:
> Would creating an /etc/adjtime as done by the postinst script be fine?
As far as I know, yes. Try it and see. The worst that can happen is
your clock will be wrong, but that's already the case, right?
ced with?
>From what I can tell, it's created by hwclock. If you run hwclock --set
it should be created. Possibly you can also run
timedatectl set-local-rtc 0
but I don't know if that works if the file doesn't exist.
> I just want to set the hardware clock to local time s
On Fri, Feb 11, 2022 at 12:54:01PM +0100, José Luis González wrote:
> According to
>
> https://wiki.debian.org/DateTime
>
> There should be an /etc/adjtime file to configure the timezone for the
> hardware clock.
That's... not how I'd describe that file, but I suppose "telling whether
the HW clo
According to
https://wiki.debian.org/DateTime
There should be an /etc/adjtime file to configure the timezone for the
hardware clock. I have no such file in my Debian 11 laptop. May I know
if the file was removed and what was it replaced with?
I just want to set the hardware clock to local time
concept of time).
So when I boot to windows the displayed time is the actual local time,
but when
I boot into Debian the displayed time is four hours behind local time.
If I do a
date -u the time that is displayed is the correct local time.
I have modified /etc/adjtime and removed the UTC line, but
; > > installer that the system clock is set to UTC, when it is not (because
> > > windows
> > > has no real concept of time).
> > >
> > > So when I boot to windows the displayed time is the actual local time,
> > > but when
> > > I b
of time).
> >
> > So when I boot to windows the displayed time is the actual local time,
> > but when
> > I boot into Debian the displayed time is four hours behind local time.
> > If I do a
> > date -u the time that is displayed is the correct local time.
>
Paul Scott wrote:
Johannes Wiedersich wrote:
Paul Scott wrote:
That was ugly! Since I have a time configuration problem I just
tried this suggestion. I had manually installed all my packages.
Since I chose nothing at the install packages step it is about to
remove some of my vital packa
Johannes Wiedersich wrote:
Paul Scott wrote:
That was ugly! Since I have a time configuration problem I just
tried this suggestion. I had manually installed all my packages.
Since I chose nothing at the install packages step it is about to
remove some of my vital packages.
Sorry. bas
Johannes Wiedersich wrote:
Ken Heard wrote:
In any event I ran it just now and found that the KDE clock applet
in the lower right corner of the panel now shows local time when it
should, rather than UTC.
base-config configures the settings for the system time. Each user can
opt to
[snip]
There is no advantage to have the sun go down "one hour earlier" in winter than
in summer
[snip]
Actualy it's the other way around. The winter time is the "real" one ;)
Andrei
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROT
On Friday, 9 December 2005 at 10:53:09 +0100, Johannes Wiedersich wrote:
> Personally, I hate this switching altogether: There is no advantage to
> have the sun go down "one hour earlier" in winter than in summer; the
> length of a day is independent of the fact that silly authorities change
>
Ken Heard wrote:
In any event I ran it just now and found that the KDE clock applet
in the lower right corner of the panel now shows local time when it
should, rather than UTC.
base-config configures the settings for the system time. Each user can
opt to configure the kde clock to show
Paul Scott wrote:
That was ugly! Since I have a time configuration problem I just tried
this suggestion. I had manually installed all my packages. Since I
chose nothing at the install packages step it is about to remove some of
my vital packages.
Sorry. base-config shows a menu, where yo
Ken Heard wrote:
Johannes Wiedersich wrote, in part:
Why don't you set up your system time via
# base-config
That was ugly! Since I have a time configuration problem I just tried
this suggestion. I had manually installed all my packages. Since I
chose nothing at the install packages st
and found that the KDE clock applet in
the lower right corner of the panel now shows local time when it should,
rather than UTC.
I use ntpdate to synchronize my clock at boot and ntp to keep it in sync
while it is up. The default set-up (without changing any configuration
files) of the two
Ken Heard wrote:
On boot I want to have the system clock set to local time -- Eastern
Standard Time (EST) in my case. First, I want rdate to be run on daily
boot to set the hardware clock, which would consequently always be set
to UDC. Second, the system clock on boot would have to be
On boot I want to have the system clock set to local time -- Eastern
Standard Time (EST) in my case. First, I want rdate to be run on daily
boot to set the hardware clock, which would consequently always be set
to UDC. Second, the system clock on boot would have to be set in local
time by
> Dos anyone know where or how in the kernal does the machine time gets
> converted to local time? I'm most curious as to how DST gets
> figured.
> For example, the machine runs on UTC, but I can set my TZ=EST.
>
> When I get my local time, it tells me if I'm in D
Dos anyone know where or how in the kernal does the machine time gets
converted to local time? I'm most curious as to how DST gets
figured.
For example, the machine runs on UTC, but I can set my TZ=EST.
When I get my local time, it tells me if I'm in DST or not (the kernal
must
also b
Hugo writes:
> Is there something else I can look at to find out what is happening?
Check /etc/default/rcS.
--
John Hasler
[EMAIL PROTECTED]
Dancing Horse Hill
Elmwood, Wisconsin
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED
Hi,
I think this subject has been beaten to death, but...
I set /etc/localtime to point to
/usr/share/zoneinfo/SystemV/CST6CDT,
I set /etc/timezone to say "SystemV/CST6CDT" and I
install chrony (or ntpdate) and they promptly set the
clock to GMT, 7 hours ahead.
http://www.tldp.org/HOWTO/Clock.ht
Paul Mackinney writes:
> Why doesn't 'apropos UTC' find this? The option is documented in the rcS
> man page.
Apropos searches only the "short description" that follows the name.
--
John Hasler
[EMAIL PROTECTED]
Dancing Horse Hill
Elmwood, Wisconsin
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED
Vineet Kumar declaimed:
> * [EMAIL PROTECTED] ([EMAIL PROTECTED]) [030530 10:28]:
> > Silly question 2 of 3: Now that my dual boot is working again, I'd like
> > the time to be correct when I run Windows. I know that during
> > installation I can tell the system that th
* [EMAIL PROTECTED] ([EMAIL PROTECTED]) [030530 10:28]:
> Silly question 2 of 3: Now that my dual boot is working again, I'd like
> the time to be correct when I run Windows. I know that during
> installation I can tell the system that the hw clock should be local
> time, but c
On Fri, 30 May 2003 10:08:40 -0700
[EMAIL PROTECTED] wrote:
> Silly question 2 of 3: Now that my dual boot is working again, I'd like
> the time to be correct when I run Windows. I know that during
> installation I can tell the system that the hw clock should be local
> time,
Silly question 2 of 3: Now that my dual boot is working again, I'd like
the time to be correct when I run Windows. I know that during
installation I can tell the system that the hw clock should be local
time, but can't seem to find out to switch it now. Doesn't seem to be
covered
On 22-Jun 05:24, Steve Kowalik wrote:
> On Fri, Jun 22, 2001 at 03:57:52AM +, John Patton uttered:
> > My systems clock is set for my local time zone (or used to
> > be), which always worked well before. Now it lists the time
> > in UTC (correctly, meaning that the time
On Fri, Jun 22, 2001 at 03:57:52AM +, John Patton uttered:
> My systems clock is set for my local time zone (or used to
> be), which always worked well before. Now it lists the time
> in UTC (correctly, meaning that the time listed is about
> 5 hours off of the actual time). Thi
My systems clock is set for my local time zone (or used to
be), which always worked well before. Now it lists the time
in UTC (correctly, meaning that the time listed is about
5 hours off of the actual time). This is causing problems
with cron. Anybody remember where to configure that stuff?
/etc
Quoting Raghavendra Bhat ([EMAIL PROTECTED]):
> Michael A. Miller posts:
>
> > I've just added a win98 partition to a debian machine
Sorry, I missed this as you'd threaded it onto an unrelated thread.
Try using send, rather than replying and modifying the subject.
> Adding a Win 9x partition has
Michael A. Miller posts:
> I've just added a win98 partition to a debian machine
Adding a Win 9x partition has nothing to do with the
Debian system you have. Why are you coming to the
conclusion that 1+5=7 without doing some research first ?
> I've changed "UTC=yes" to "UTC=no" in /etc/defaul
I've just added a win98 partition to a debian machine and would
like to arrange for the hardware clock to use local time.
I've changed "UTC=yes" to "UTC=no" in /etc/default/rcS, but my
system is still getting changed back to utc. Can anyone point me
to what else
;
> > Hi everybody,
> >
> > I used to have a machine running Windows and Linux, but now I decided to
> > get rid off win.
> >
> > Currently, I have setup which relyes on BIOS clock set to local time.
> > Since, I am converiting to linux only, I want to cha
Just edit the file
/etc/default/rcS
and change the line with UTC to
UTC=yes
Lazar Fleysher wrote:
> Hi everybody,
>
> I used to have a machine running Windows and Linux, but now I decided to
> get rid off win.
>
> Currently, I have setup which relyes on BIOS clock set to l
Hi everybody,
I used to have a machine running Windows and Linux, but now I decided to
get rid off win.
Currently, I have setup which relyes on BIOS clock set to local time.
Since, I am converiting to linux only, I want to change that.
I know how to set the BIOS clock to UT time :-), but which
On 02-Nov-2000 Kerstin Hoef-Emden wrote:
>
> Hi,
>
> until yet I could not find docs describing this procedure on an already
> installed system. Where are changes necessary? I know that an entry in
> /etc/default/rcS can be changed and afterwards settings have to be done
> with hwclock, but is t
Hi,
until yet I could not find docs describing this procedure on an already
installed system. Where are changes necessary? I know that an entry in
/etc/default/rcS can be changed and afterwards settings have to be done
with hwclock, but is this all it needs? Besides that, I have no idea to
what t
I recently installed chrony, but it seems to be setting my clock to GMT
rather than local time, i.e. it's one hour late compared to UK's current
time. My Linux was installed with the hardware clock set to local time,
because it shares the machine with Windows. How do I tell chrony
In article <[EMAIL PROTECTED]>, Jairo Souto <[EMAIL PROTECTED]> wrote:
>[EMAIL PROTECTED] wrote:
>You have to change the line in /etc/default/rcS which states
>the CMOS clock configuration, haven't you?
>
>
># Set GMT="-u" if your system clock is set to GMT, and GMT="" if not.
>GMT=
[EMAIL PROTECTED] wrote:
>
> Run tzconfig.
>
> On Wed, Oct 06, 1999 at 12:47:50PM +0300, Ali Onur UYAR wrote:
> > I had been using Debian since July of 1998. It had been a dual boot
> > NT/Debian Box. At the time of installation I remember selecting
> > something li
Run tzconfig.
On Wed, Oct 06, 1999 at 12:47:50PM +0300, Ali Onur UYAR wrote:
> I had been using Debian since July of 1998. It had been a dual boot
> NT/Debian Box. At the time of installation I remember selecting
> something like 'Set HW Clock to Local Time'. Now that I'v
I had been using Debian since July of 1998. It had been a dual boot
NT/Debian Box. At the time of installation I remember selecting
something like 'Set HW Clock to Local Time'. Now that I've dumped NT
completely and I want to change it to 'HW Clock set to GMT' as I believ
>> "AVT" == Alex V Toropov <[EMAIL PROTECTED]> writes:
AVT> it's executes all tasks from /etc/crontab and /etc/cron.d/* at
AVT> specified time as if it's UTC time, not local time as I'd like it
AVT> to be.
Check the debian-devel archives of late jan
Hi all,
I've faced a problem with cron:
it's executes all tasks from /etc/crontab and /etc/cron.d/*
at specified time as if it's UTC time, not local time as I'd like it to be.
date command returns correct date & time (both for local time and UTC time)
Can someone tel
Hallo,
Since I have upgraded my Debian system to Slink, my clock is not showing
the local time - universal time instead. That is when I use it as user.
Look at this:
[EMAIL PROTECTED](13)$ date
Mon Jun 14 23:41:26 SAST 1999
That is the correct time but about a minute before that:
[EMAIL
On Mon, Mar 29, 1999 at 09:42:36AM +0100, Antal Ritter wrote:
> Hi,
>
> What is the supposed behaviour of cron when the local time changes?
>
> To put it more clearly: let's suppose that on the 28th of March 2 AM
> we have to skip forward an hour due to daylight savi
>
> Hi,
>
> What is the supposed behaviour of cron when the local time changes?
>
> To put it more clearly: let's suppose that on the 28th of March 2 AM
> we have to skip forward an hour due to daylight savings time. What
> should happen to a script that is set up t
Hi,
What is the supposed behaviour of cron when the local time changes?
To put it more clearly: let's suppose that on the 28th of March 2 AM
we have to skip forward an hour due to daylight savings time. What
should happen to a script that is set up to run at eg. 2:20 AM
in my crontab file?
On Sun, 1 Nov 1998, Erik van der Meulen wrote:
> Is it possible to set some parameter to overcome this time
> zone difference? The xntp3 docs did not give an aswer, so
> I am assuming that it should be on the Linux side.
Erik,
Try 'tzconfig'.
..
please forgive my abrupt ending hre - but my
I am very pleased with my brand new kabel internet connection.
My Debian box does the masquerading trick great.
Now I would like to install a time client, in order to keep
my system up to date. I installed xntp3 and it seems to return
the time very well. The problem is that it (seems to) assume
tha
60 matches
Mail list logo