snipt

Ctrl+h for KB shortcuts

Text only

Timezone adjusted span query

1
select count(*) from members as m where date(CONVERT_TZ(m.created_at,'GMT','America/Los_Angeles')) = date(CONVERT_TZ(now(),'GMT','America/Los_Angeles'))
×

Copy “Timezone adjusted span query”

(Text is selected. +C to copy.)

×

Embed “Timezone adjusted span query”

(Text is selected. +C to copy.)

https://snipt.net/embed/941235bcc8e346718e4aa614b692402e/
/raw/941235bcc8e346718e4aa614b692402e/
941235bcc8e346718e4aa614b692402e
text
Text only
1
2024-05-19T21:29:47
True
False
False
Sep 02, 2019 at 06:16 AM
/api/public/snipt/108/
timezone-adjusted-span-query
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>select count(*) from members as m where date(CONVERT_TZ(m.created_at,&#39;GMT&#39;,&#39;America/Los_Angeles&#39;)) = date(CONVERT_TZ(now(),&#39;GMT&#39;,&#39;America/Los_Angeles&#39;)) </span></pre></div> </td></tr></table>
mysql
1
2
3
4
--- 
+++ 
@@ -0,0 +1 @@
+select count(*) from members as m where date(CONVERT_TZ(m.created_at,'GMT','America/Los_Angeles')) = date(CONVERT_TZ(now(),'GMT','America/Los_Angeles'))