Re: logging time format millisecond precision decimalsign

2012-07-20 Thread David Bolen
"Alex van der Spek" writes: > I use this formatter in logging: > > formatter = logging.Formatter(fmt='%(asctime)s \t %(name)s \t %(levelname)s > \t %(message)s') > > Sample output: > > 2012-07-19 21:34:58,382 root INFO Removed - C:\Users\ZDoor\Documents > > The time stamp has millisecond pr

Re: logging time format millisecond precision decimalsign

2012-07-20 Thread Peter Otten
Alex van der Spek wrote: > I use this formatter in logging: > > formatter = logging.Formatter(fmt='%(asctime)s \t %(name)s \t > %(levelname)s \t %(message)s') > > Sample output: > > 2012-07-19 21:34:58,382 root INFO Removed - C:\Users\ZDoor\Documents > > The time stamp has millisecond pr

logging time format millisecond precision decimalsign

2012-07-20 Thread Alex van der Spek
I use this formatter in logging: formatter = logging.Formatter(fmt='%(asctime)s \t %(name)s \t %(levelname)s \t %(message)s') Sample output: 2012-07-19 21:34:58,382 root INFO Removed - C:\Users\ZDoor\Documents The time stamp has millisecond precision but the decimal separator is a comma.

logging time format millisecond precision

2012-07-19 Thread Alex van der Spek
I use this formatter in logging: formatter = logging.Formatter(fmt='%(asctime)s \t %(name)s \t %(levelname)s \t %(message)s') Sample output: 2012-07-19 21:34:58,382 root INFO Removed - C:\Users\ZDoor\Documents The time stamp has millisecond precision but the decimal separator is a com

Logging Date/Time Format

2008-03-10 Thread Robert Rawlins
Hello Guys, I'm using the python logging module, however I'm not happy with the current date/time format which is used to write the timestamp into the log file. I need the logger to write the stamp without the milliseconds appended too it. This is because I use a 3rd party applicatio

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-10 Thread [EMAIL PROTECTED]
t; > > > example)http://www.netpro.com/forum/messageview.cfm?catid=15&threadid=457 > > > > > > For Example: the number 3566839 is 27.11.07 7:00. > > > > > Y2K bug! The number 3566839 is a representation of > > > > 2007-11-27T07:00:00. > >

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-10 Thread Dirk Hagemann
number 3566839 is 27.11.07 7:00. > > > > Y2K bug! The number 3566839 is a representation of > > > 2007-11-27T07:00:00. > > > > > To calculate this in > > > >ExcelI use this: > > > > ="01.01.1901"+(A1/24-(REST(A1;24)/24))+ZEIT(RE

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-09 Thread [EMAIL PROTECTED]
> > > To calculate this in > > >ExcelI use this: > > > ="01.01.1901"+(A1/24-(REST(A1;24)/24))+ZEIT(REST(A1;24);0;0) �(put > > > 3566839 in field A1 and switch the format of the result-field to the > > > corresponding date-time format). >

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-09 Thread Dirk Hagemann
gt; > For Example: the number 3566839 is 27.11.07 7:00. > > Y2K bug! The number 3566839 is a representation of > 2007-11-27T07:00:00. > > > To calculate this in > >ExcelI use this: > > ="01.01.1901"+(A1/24-(REST(A1;24)/24))+ZEIT(REST(A1;24);0;0) (p

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread John Machin
27T07:00:00. > To calculate this in > Excel I use this: > ="01.01.1901"+(A1/24-(REST(A1;24)/24))+ZEIT(REST(A1;24);0;0) (put > 3566839 in field A1 and switch the format of the result-field to the > corresponding date-time format). "01.01.1901" => date(1901

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread [EMAIL PROTECTED]
On Dec 7, 9:59 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > On 7 Dez., 16:50, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > > > > > On 7 Dez., 16:21, Tim Golden <[EMAIL PROTECTED]> wrote: > > > > [EMAIL PROTECTED] wrote: > > > > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > >

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Boris Borcic
Dirk Hagemann wrote: > (3566839/24)/365 = 407 - YES I did this calculation too and was > surprised. But if you try this out in MS Excel: > ="01.01.1901"+(A1/24-(REST(A1;24)/24))+ZEIT(REST(A1;24);0;0) (put > 3566839 in field A1 and switch the format of the result-fieldby right- > click on it to

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Max Erickson
Dirk Hagemann <[EMAIL PROTECTED]> wrote: >> Dirk > Additional to my last posting: if you want to try this out in > Excel you should replace the command "REST" by the english > command what should be something like "remainder". The equivalent in my (U.S. English, 2000) version of excel is called

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Zentrader
If we use minutes from 2001, then 3566839 comes out as sometime in October, 2007 (6.78622 years). Close but no cigar. Is anyone familar enough with Excel to translate the formula or do we have to go a- googling? -- http://mail.python.org/mailman/listinfo/python-list

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
On 7 Dez., 16:50, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > On 7 Dez., 16:21, Tim Golden <[EMAIL PROTECTED]> wrote: > > > > > [EMAIL PROTECTED] wrote: > > > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > >> Hello, > > > >> From a zone-file of a Microsoft Active Directory integrate

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
On 7 Dez., 16:50, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > On 7 Dez., 16:21, Tim Golden <[EMAIL PROTECTED]> wrote: > > > > > [EMAIL PROTECTED] wrote: > > > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > >> Hello, > > > >> From a zone-file of a Microsoft Active Directory integrate

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
On 7 Dez., 16:21, Tim Golden <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > >> Hello, > > >> From a zone-file of a Microsoft Active Directory integrated DNS server > >> I get the date/time of the dynamic update entries in a fo

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Giles Brown
For Example: the number 3566839 is 27.11.07 7:00. To calculate this in > Excel I use this: > ="01.01.1901"+(A1/24-(REST(A1;24)/24))+ZEIT(REST(A1;24);0;0) (put > 3566839 in field A1 and switch the format of the result-field to the > corresponding date-time format). > > You m

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Tim Golden
[EMAIL PROTECTED] wrote: > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: >> Hello, >> >> From a zone-file of a Microsoft Active Directory integrated DNS server >> I get the date/time of the dynamic update entries in a format, which >> is as far as I know the hours since january 1st 19

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread supercooper
> Excel I use this: > > > ="01.01.1901"+(A1/24-(REST(A1;24)/24))+ZEIT(REST(A1;24);0;0) (put > > > 3566839 in field A1 and switch the format of the result-field to the > > > corresponding date-time format). > > > > You might guess what I need now: I w

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread [EMAIL PROTECTED]
of the result-field to the > corresponding date-time format). > > You might guess what I need now: I want to calculate this somehow in > python. > > Sorry, but I couldn't find anything in the module time or something > else to get this calculated. > > Does anyone know

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
(put > > 3566839 in field A1 and switch the format of the result-field to the > > corresponding date-time format). > > > You might guess what I need now: I want to calculate this somehow in > > python. > > > Sorry, but I couldn't find anything in the module time or some

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread supercooper
For Example: the number 3566839 is 27.11.07 7:00. To calculate this in > Excel I use this: > ="01.01.1901"+(A1/24-(REST(A1;24)/24))+ZEIT(REST(A1;24);0;0) (put > 3566839 in field A1 and switch the format of the result-field to the > corresponding date-time format). > >

Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
his: ="01.01.1901"+(A1/24-(REST(A1;24)/24))+ZEIT(REST(A1;24);0;0) (put 3566839 in field A1 and switch the format of the result-field to the corresponding date-time format). You might guess what I need now: I want to calculate this somehow in python. Sorry, but I couldn't find anything in

Re: time format

2007-05-15 Thread Paul Boddie
On 15 May, 12:29, Alchemist <[EMAIL PROTECTED]> wrote: > > How can I format a ctime() object? > Can anyone give me (or lead me to) an example of a solution to my > problem? Use time.strftime. See... http://docs.python.org/lib/module-time.html#tex2html122 Paul -- http://mail.python.org/mailman/

time format

2007-05-15 Thread Alchemist
I have a ctime() object that when I convert to string returns this string: "Tue May 15 12:27:11 2007" Now I need to convert it in the following (string) format: "Tue, 15 May 2007 10:25:40 GMT" How can I format a ctime() object? Can anyone give me (or lead me to) an example of a solution to my