snipt

Ctrl+h for KB shortcuts

PHP

Convert MM/DD/YYYY date to YYYY-MM-DD with PHP

1
2
3
4
5
6
7
8
<?
function convertDate($date) {
	$date = preg_replace('/\D/','/',$date);
	return date('Y-m-d',strtotime($date));
}

print convertDate('11/05/1996'); //prints 1996-11-05
?>
https://snipt.net/embed/2325e463da0114ccc684fbc7ba9e2a00/
/raw/2325e463da0114ccc684fbc7ba9e2a00/
2325e463da0114ccc684fbc7ba9e2a00
php
PHP
8
2019-06-24T12:43:27
True
False
False
/api/public/snipt/14231/
convert-date-to-yyyy-mm-dd-with-php
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a> <a href="#L-6">6</a> <a href="#L-7">7</a> <a href="#L-8">8</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="cp">&lt;?</span> </span><span id="L-2"><a name="L-2"></a><span class="k">function</span> <span class="nf">convertDate</span><span class="p">(</span><span class="nv">$date</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-3"><a name="L-3"></a> <span class="nv">$date</span> <span class="o">=</span> <span class="nb">preg_replace</span><span class="p">(</span><span class="s1">&#39;/\D/&#39;</span><span class="p">,</span><span class="s1">&#39;/&#39;</span><span class="p">,</span><span class="nv">$date</span><span class="p">);</span> </span><span id="L-4"><a name="L-4"></a> <span class="k">return</span> <span class="nb">date</span><span class="p">(</span><span class="s1">&#39;Y-m-d&#39;</span><span class="p">,</span><span class="nb">strtotime</span><span class="p">(</span><span class="nv">$date</span><span class="p">));</span> </span><span id="L-5"><a name="L-5"></a><span class="p">}</span> </span><span id="L-6"><a name="L-6"></a> </span><span id="L-7"><a name="L-7"></a><span class="k">print</span> <span class="nx">convertDate</span><span class="p">(</span><span class="s1">&#39;11/05/1996&#39;</span><span class="p">);</span> <span class="c1">//prints 1996-11-05</span> </span><span id="L-8"><a name="L-8"></a><span class="cp">?&gt;</span><span class="x"></span> </span></pre></div> </td></tr></table>
convert, date, iso

MySQL

Calculate the difference between dates in on column within the same table

1
2
3
4
SELECT DATEDIFF(
 (SELECT DATE(date_field) FROM table WHERE id = '1' AND status_id = '2' ORDER BY date_field DESC LIMIT 1),
 (SELECT DATE(date_field) FROM table WHERE id = '1' AND status_id = '1' ORDER BY date_field DESC LIMIT 1)
	) AS difference
https://snipt.net/embed/92c1f8bbeb80a7a6033d40cae85dcd24/
/raw/92c1f8bbeb80a7a6033d40cae85dcd24/
92c1f8bbeb80a7a6033d40cae85dcd24
mysql
MySQL
4
2019-06-26T01:14:21
True
False
False
/api/public/snipt/14227/
calculate-the-difference-between-dates-in-one-columns-within-the-same-table
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="k">SELECT</span> <span class="nf">DATEDIFF</span><span class="p">(</span> </span><span id="L-2"><a name="L-2"></a> <span class="p">(</span><span class="k">SELECT</span> <span class="kt">DATE</span><span class="p">(</span><span class="n">date_field</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">table</span> <span class="k">WHERE</span> <span class="n">id</span> <span class="o">=</span> <span class="s1">&#39;1&#39;</span> <span class="k">AND</span> <span class="n">status_id</span> <span class="o">=</span> <span class="s1">&#39;2&#39;</span> <span class="k">ORDER</span> <span class="k">BY</span> <span class="n">date_field</span> <span class="k">DESC</span> <span class="k">LIMIT</span> <span class="mi">1</span><span class="p">),</span> </span><span id="L-3"><a name="L-3"></a> <span class="p">(</span><span class="k">SELECT</span> <span class="kt">DATE</span><span class="p">(</span><span class="n">date_field</span><span class="p">)</span> <span class="k">FROM</span> <span class="k">table</span> <span class="k">WHERE</span> <span class="n">id</span> <span class="o">=</span> <span class="s1">&#39;1&#39;</span> <span class="k">AND</span> <span class="n">status_id</span> <span class="o">=</span> <span class="s1">&#39;1&#39;</span> <span class="k">ORDER</span> <span class="k">BY</span> <span class="n">date_field</span> <span class="k">DESC</span> <span class="k">LIMIT</span> <span class="mi">1</span><span class="p">)</span> </span><span id="L-4"><a name="L-4"></a> <span class="p">)</span> <span class="k">AS</span> <span class="n">difference</span> </span></pre></div> </td></tr></table>
change, date, datediff, difference, mysql, status, subquery

Perl

Getting actual date in Perl

$DDMMYYHHMMSS = sprintf("%02d/%02d/%04d %02d:%02d:%02d", sub{($_[3],$_[4]+1,$_[5]+1900,$_[2],$_[1]),$_[0]}->(localtime(time())));
https://snipt.net/embed/66fd04d5186c58507a006d5231fd68ec/
/raw/66fd04d5186c58507a006d5231fd68ec/
66fd04d5186c58507a006d5231fd68ec
perl
Perl
1
2019-06-17T16:07:00
True
False
False
/api/public/snipt/11371/
get-formated-date
<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><span class="nv">$DDMMYYHHMMSS</span> <span class="o">=</span> <span class="nb">sprintf</span><span class="p">(</span><span class="s">&quot;%02d/%02d/%04d %02d:%02d:%02d&quot;</span><span class="p">,</span> <span class="n">sub</span><span class="p">{(</span><span class="nv">$_</span><span class="p">[</span><span class="mi">3</span><span class="p">],</span><span class="nv">$_</span><span class="p">[</span><span class="mi">4</span><span class="p">]</span><span class="o">+</span><span class="mi">1</span><span class="p">,</span><span class="nv">$_</span><span class="p">[</span><span class="mi">5</span><span class="p">]</span><span class="o">+</span><span class="mi">1900</span><span class="p">,</span><span class="nv">$_</span><span class="p">[</span><span class="mi">2</span><span class="p">],</span><span class="nv">$_</span><span class="p">[</span><span class="mi">1</span><span class="p">]),</span><span class="nv">$_</span><span class="p">[</span><span class="mi">0</span><span class="p">]}</span><span class="o">-&gt;</span><span class="p">(</span><span class="nb">localtime</span><span class="p">(</span><span class="nb">time</span><span class="p">())));</span> </span></pre></div> </td></tr></table>
date, formated, perl

PHP

little date dealy for converting mysql date fomats to mm/yy/dd

1
2
3
$dt = '0000-00-00 00:00:00';
".substr($dt,5,2)."/".substr($dt,8,2)." //dd/mm
".substr($dt,11,2).":".substr($dt,14,2)." //hh:mm
https://snipt.net/embed/7906f18877ae5aba44b233d3c0cb323c/
/raw/7906f18877ae5aba44b233d3c0cb323c/
7906f18877ae5aba44b233d3c0cb323c
php
PHP
3
2019-06-17T09:09:03
True
False
False
/api/public/snipt/9372/
little-date-dealy-for-converting-mysql-date-fomats-to-mmyydd
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="x">$dt = &#39;0000-00-00 00:00:00&#39;;</span> </span><span id="L-2"><a name="L-2"></a><span class="x">&quot;.substr($dt,5,2).&quot;/&quot;.substr($dt,8,2).&quot; //dd/mm</span> </span><span id="L-3"><a name="L-3"></a><span class="x">&quot;.substr($dt,11,2).&quot;:&quot;.substr($dt,14,2).&quot; //hh:mm</span> </span></pre></div> </td></tr></table>
date, mysql, yy//mm/dd

JavaScript

date in italian format

1
2
3
4
5
6
7
8
function today() {
	var dt= new Date();
	dt.setDate(dt.getDate());
	var yyyy = dt.getFullYear();
	var mm = ('0' +	parseInt(dt.getMonth()+1).toString()).slice(-2);
	var dd = ('0' + dt.getDate().toString()).slice(-2);
	return dd+'/'+mm+'/'+yyyy;	
}
https://snipt.net/embed/b36fb8b7ed3927eca62a107973f95f15/
/raw/b36fb8b7ed3927eca62a107973f95f15/
b36fb8b7ed3927eca62a107973f95f15
js
JavaScript
8
2019-06-24T14:56:15
True
False
False
/api/public/snipt/9179/
date-in-italian-format
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a> <a href="#L-6">6</a> <a href="#L-7">7</a> <a href="#L-8">8</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="kd">function</span> <span class="nx">today</span><span class="p">()</span> <span class="p">{</span> </span><span id="L-2"><a name="L-2"></a> <span class="kd">var</span> <span class="nx">dt</span><span class="o">=</span> <span class="k">new</span> <span class="nb">Date</span><span class="p">();</span> </span><span id="L-3"><a name="L-3"></a> <span class="nx">dt</span><span class="p">.</span><span class="nx">setDate</span><span class="p">(</span><span class="nx">dt</span><span class="p">.</span><span class="nx">getDate</span><span class="p">());</span> </span><span id="L-4"><a name="L-4"></a> <span class="kd">var</span> <span class="nx">yyyy</span> <span class="o">=</span> <span class="nx">dt</span><span class="p">.</span><span class="nx">getFullYear</span><span class="p">();</span> </span><span id="L-5"><a name="L-5"></a> <span class="kd">var</span> <span class="nx">mm</span> <span class="o">=</span> <span class="p">(</span><span class="s1">&#39;0&#39;</span> <span class="o">+</span> <span class="nb">parseInt</span><span class="p">(</span><span class="nx">dt</span><span class="p">.</span><span class="nx">getMonth</span><span class="p">()</span><span class="o">+</span><span class="mi">1</span><span class="p">).</span><span class="nx">toString</span><span class="p">()).</span><span class="nx">slice</span><span class="p">(</span><span class="o">-</span><span class="mi">2</span><span class="p">);</span> </span><span id="L-6"><a name="L-6"></a> <span class="kd">var</span> <span class="nx">dd</span> <span class="o">=</span> <span class="p">(</span><span class="s1">&#39;0&#39;</span> <span class="o">+</span> <span class="nx">dt</span><span class="p">.</span><span class="nx">getDate</span><span class="p">().</span><span class="nx">toString</span><span class="p">()).</span><span class="nx">slice</span><span class="p">(</span><span class="o">-</span><span class="mi">2</span><span class="p">);</span> </span><span id="L-7"><a name="L-7"></a> <span class="k">return</span> <span class="nx">dd</span><span class="o">+</span><span class="s1">&#39;/&#39;</span><span class="o">+</span><span class="nx">mm</span><span class="o">+</span><span class="s1">&#39;/&#39;</span><span class="o">+</span><span class="nx">yyyy</span><span class="p">;</span> </span><span id="L-8"><a name="L-8"></a><span class="p">}</span> </span></pre></div> </td></tr></table>
date, javascript