Is there a way to change sqlite to use my machine's TZ instead of GMT ?  CURRENT_TIMESTAMP is currently displaying GMT.  I need it as the default value for a record timestamp column.
I have a sqlite (v3) table with this column definition:  "timestamp" DATETIME DEFAULT CURRENT_TIMESTAMP   The server that this database lives on is in the CST time zone.  When I insert into my table without including the timestamp column, sqlite automatically populates that field with the current timestamp in GMT, not CST.  Is there a way to modify my insert statement to force the stored timestamp to be in CST?  On the other hand, it is probably better to store it in GMT (in case the database gets moved to a different timezone, for example), so is there a way I can modify my select SQL to convert the stored timestamp to CST when I extract it from the table?
google search index what is fresh content I read that sites have good reputation in google search index if it is fresh content.  what does fresh content means from google's point of view?  I have many pages. I have created articles and tutorials.  These page dosent change except the comments which are at the bottom.  I have made this page as static (.html) and never edit cause that is the information i wanted to be ever. cause the concept is not going to change?  with these parameters how to judge whether my page is fresh or not? How does Mathematica integrate? How to remove link for an application in new Google Launcher? This is a follow-up to this question:   Hans Bethe wrote a paper in 1944, "Theory of Diffraction by Small Holes," Phys. Rev. 66, 163. I don't have access to the paper, but from descriptions online it sounds like he proved the following. Suppose a plane wave impinges on an absorbing sheet, and there is a hole in the sheet of diameter $d$, with $d&lt;\lambda$. Let $P_0$ be the power incident on the hole, and $P$ the power diffracted through the hole. Then the transmission is $T=P/P_0=(d/\lambda)^4$.  As a practical application, I think this explains why microwaves don't leak strongly through the metal grille in the front of a microwave oven.  Questions:   Does the thickness of the sheet matter? From references online, it sounds like the hole is treated as a waveguide...? This seems to relate to cutoff frequencies of waveguides, etc.? It seems to me that Huygens' principle would give $T=1$ for $d\ll\lambda$, since in this limit the wavelets are in phase. Why is Huygens' principle invalid here? Is this related to question #1? Is there a simple argument for the proportionality to $(d/\lambda)^4$? Or if not, how does one prove this using the gory details of Bessel functions, etc.? Do photons have acceleration? "Give him a box that everyone knows what it contains."  Is this correct English? It sounds wrong to me. How do I sudo a command in a script without being asked for a password? I want to turn my system on automatically every day. So I use the below code in my Python script, but sudo asks me for a password every time:  os.system('sudo sh -c "echo date \'+%s\' -d \'+ \        24 hours\' &gt; /sys/class/rtc/rtc0/wakealarm"')   How can I run this script without sudo asking for the password every time? Haproxy not logging captured request headers with custom log format Earlier i was not specifying a custom log format, and the captured request headers were getting printed fine. I wanted to log the unique-id-header, but could not find any way of doing so. So i copy pasted the log-format mentioned on , and unique id started getting logged.  Unfortunately, now the captured request headers are not getting logged. The %hrl and %hsl are coming out as empty strings.  Very weird. Here is my config, plzz help :(  listen server   bind *:80   mode http    option  httplog   option  http-server-close   no option logasap   # disable early logging of HTTP requests so that total transfer time is logged   option  forwardfor   capture request  header    X-Forwarded-For      len 500    capture request  header    Host                 len 500    capture request  header    X-Request-UID        len 500    rspadd  X-Haproxy-Backend:\ server    # Generate the X-Haproxy-Unique-ID and log it to make it easy to track requests   log-format %Ci:%Cp\ [id=%ID]\ [%t]\ %f\ %b/%s\ %Tq/%Tw/%Tc/%Tr/%Tt\ %st\ %B\ %cc\ %cs\ %tsc\ %ac/%fc/%bc/%sc/%rc\ %sq/%bq\ {%hrl}\ {%hsl}\ %{+Q}r   unique-id-format %{+X}o\ %Ci:%Cp_%Fi:%Fp_%Ts_%rt:%pid   unique-id-header X-Haproxy-Unique-ID   Here is the log i see:  Sep 13 17:28:57 localhost haproxy[11979]: 10.161.27.218:41592  [id=0AA11BDA:A278_0AA15B71:0050_505217C5_0014:2ECB] [13/Sep/2012:17:28:37.567]  server www-example-com-healthz/- 19998/0/2/1/+20001 200 +326  - - ---- 10/10/1/1/0 0/0 {} {}  "GET /testing/healthz?merchant=www.example.com&amp;source=elb HTTP/1.1"   Note that %hrl and %hsl are empty strings :( How do i capture the request headers ?? Could it be that Goldbach conjecture is undecidable? How much memory can a 32 bit process access on a 64 bit operating system? How to place a .png texture with transparency over a material How to connect to wifi using just the terminal? I'm writing a set of course notes that has an appendix containing many activities.   I do not wish the activities to be shown in the Table of Contents, but I do wish them to be numbered. Here is the solution I was using:  In the preamble:  \newcommand{\activity}[2]{\bgroup\let\addcontentsline=\nocontentsline#1{#2}\egroup}   and now my "activity" starts out with:  \newpage \activity\section{A Fun Educational Activity}   There is only one problem. The activity starts out indented, as opposed to not indented, as a section should be.   How do I make my activity start out without an indent?  I realize I could simply add \noindent but it seems to me that there should be a more elegant solution. How do I remove code duplication between similar const and non-const member functions? What is the memory layout of a .NET array?  Take for instance this array:  Int32[] x = new Int32[10];   I understand that the bulk of the array is like this:  0000111122223333444455556666777788889999   Where each character is one byte, and the digits corresponds to indices into the array.  Additionally, I know that there is a type reference, and a syncblock-index for all objects, so the above can be adjusted to this:  ttttssss0000111122223333444455556666777788889999         ^         +- object reference points here   Additionally, the length of the array needs to be stored, so perhaps this is more correct:  ttttssssllll0000111122223333444455556666777788889999         ^         +- object reference points here   Is this complete? Are there more data in an array?  The reason I'm asking is that we're trying to estimate how much memory a couple of different in-memory representations of a rather large data corpus will take and the size of the arrays varies quite a bit, so the overhead might have a large impact in one solution, but perhaps not so much in the other.  So basically, for an array, how much overhead is there, that is basically my question.  And before the arrays are bad squad wakes up, this part of the solution is a static build-once-reference-often type of thing so using growable lists is not necessary here. Using NPN transistor as switch Can you make a non-polar electrolytic capacitor out of two regular electrolytic capacitors? There was a film from the 80s in which young people can teleport anywhere they can think of.   These guys are recruited to do studies with, maybe by the government or a secret company which wants the take advantage of their abilities.   I saw it on cable TV around 1990-1997.   Any clues? ASP.NET "special" tags How to get a list of the filenames of the figures embedded in a document I have a TeX document that is embedding a huge amount of figures from a fig folder that is full of another humongous amount of other figures.  I would like to move the document along with its figures, but I don't want to take the whole fig folder, just the figures in there that are embedded by the document.  Is there a package (or any other way) that allows me to, for example, print out the filenames of all the figures embedded by the document? Something like:  fig/figurename1.eps fig/figurename2.eps ... etc   I could then just copy-paste that list and add some cp's in a plain text file and automate the copy of those files to my desired location by running the file in my shell:  $ cp fig/figurename1.eps wherever/fig/ $ cp fig/figurename2.eps wherever/fig/ ... etc   Of course this is just an idea, if somebody has an alternative to the "file listing and copy-pasting in a shell file" I would be happy to listen =)