mysql：获取系统当前的数字形式时…

bjghzly

<wbr>mysql：获取系统当前的数字形式时间值</wbr>

UNIX_TIMESTAMP(date)<wbr></wbr>
返回一个Unix时间戳(从'1970-01-01<wbr>00:00:00'GMT开始的秒数,date默认值为当前时间)</wbr>
eg:
1<wbr></wbr>mysql><wbr></wbr>select<wbr></wbr>UNIX_TIMESTAMP();<wbr><wbr><wbr><wbr><wbr> 　　<br><span style="color: rgb(160, 176, 192); font-style: italic;">2<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(32, 32, 32);">-&gt;</span><span><wbr></wbr></span><span style="color: rgb(64, 160, 112);">882226357</span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><wbr><span><wbr></wbr></span><br><span style="color: rgb(160, 176, 192); font-style: italic;">3<wbr></wbr></span><span style="color: rgb(32, 32, 32);">mysql</span><span style="color: rgb(32, 32, 32);">&gt;</span><span><wbr></wbr></span><span style="color: rgb(0, 112, 32); font-weight: bold;">select</span><span><wbr></wbr></span><span style="color: rgb(6, 40, 126); font-style: italic;">UNIX_TIMESTAMP</span>(<span style="color: rgb(64, 112, 160);">'1997-10-0422:23:00'</span>); <wbr><wbr><wbr><wbr><wbr> 　　<br><span style="color: rgb(160, 176, 192); font-style: italic;">4<wbr></wbr></span><span><wbr></wbr></span><wbr><wbr><span style="color: rgb(32, 32, 32);">-&gt;</span><span><wbr></wbr></span><span style="color: rgb(64, 160, 112);">875996580</span><br><span style="color: rgb(248, 16, 176);">5<wbr></wbr></span><span style="color: rgb(32, 32, 32);">mysql</span><span style="color: rgb(32, 32, 32);">&gt;</span><span><wbr></wbr></span><span style="color: rgb(0, 112, 32); font-weight: bold;">select</span><span><wbr></wbr></span><span style="color: rgb(6, 40, 126); font-style: italic;">UNIX_TIMESTAMP</span>();<wbr><wbr><wbr><wbr><wbr><br><span style="color: rgb(160, 176, 192); font-style: italic;">6<wbr></wbr></span>　　<span style="color: rgb(32, 32, 32);">-&gt;</span><span><wbr></wbr></span><span style="color: rgb(64, 160, 112);">882226357</span><span><wbr></wbr></span><wbr><wbr><wbr><wbr><wbr><br><span style="color: rgb(160, 176, 192); font-style: italic;">7<wbr></wbr></span><span style="color: rgb(32, 32, 32);">mysql</span><span style="color: rgb(32, 32, 32);">&gt;</span><span><wbr></wbr></span><span style="color: rgb(0, 112, 32); font-weight: bold;">select</span><span><wbr></wbr></span><span style="color: rgb(6, 40, 126); font-style: italic;">UNIX_TIMESTAMP</span>(<span style="color: rgb(64, 112, 160);">'1997-10-0422:23:00'</span>); <wbr><wbr><wbr><wbr><wbr><br><span style="color: rgb(160, 176, 192); font-style: italic;">8<wbr></wbr></span>　　<span style="color: rgb(32, 32, 32);">-&gt;</span><span><wbr></wbr></span><span style="color: rgb(64, 160, 112);">875996580</span></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>