Hive（包括impala）sql 转换13位毫秒时间戳方法

于由Kael Wang发布

原生函数from_unixtime(BIGINT unixtime [, STRING format])使用时间戳为标准unix时间戳，单位必须是秒，但是一般在入库中，基础数据存入的都是13位的毫秒时间戳，例如startdate为BIGINT格式，转化为秒，startdate/1000，但结果变为DOUBLE格式，此时先用cast进行转换，

from_unixtime(cast(startdate/1000 as bigint)) as new_startdate
#例如如下sql用例：
select startdate,from_unixtime(cast(startdate/1000 as bigint),'yyyy-MM-dd HH:mm:ss') as new_startdate from sip where day=20210903 and hour='10' limit 10;
分类： Hadoop生态大数据

82 条评论

http://www.google.tt/ · 2026-08-21 01:42

References:

Bellagio casino las vegas http://www.google.tt/

回复

http://images.google.co.th/ · 2026-08-21 05:43

References:

Blackjack strategy http://images.google.co.th/

回复

khamtaopattana.go.th · 2026-08-22 03:35

References:

Play online games games khamtaopattana.go.th

回复

foro.cazadividendos.com · 2026-08-22 22:55

References:

Dallas casino foro.cazadividendos.com

回复

gg panalo · 2026-08-23 12:51

Understanding variance is key in any game, and seeing platforms like gg panalo casino disclose RTP helps players make informed choices. It’s smart to align risk tolerance with game volatility – crucial for long-term strategy!

回复

nn777slot · 2026-08-24 08:51

Interesting take on bankroll management! Reminds me of the focused approach at nn777 slot slot download-classic games with a modern, secure feel. Good article, definitely worth a read!

回复

melbetg · 2026-09-04 05:41

[1944]melbetg লগইন ও অ্যাপ ডাউনলোড | বিকাশ দিয়ে অনলাইন ক্যাসিনো,melbetg লগইন করুন এবং সেরা স্লট গেম সাইটের অভিজ্ঞতা নিন। বিকাশ দিয়ে অনলাইন ক্যাসিনো পেমেন্ট এবং লাইভ ক্যাসিনো খেলার নিয়ম জানতে আজই জয়েন করুন। visit: melbetg

回复

bilivideos.cc · 2026-09-18 06:07

I have too thaank youu ffor thhe fforts you’ve put in writing this website.

I reall hlpe too see thee same high-grade blog posts from yyou
laster onn as well. In fact, your ccreative wriring abilities
has inspured mme tto geet mmy own, persnal weebsite noow
😉 xnxx

回复

Sofort Casino Erfahrungen · 2026-09-22 05:21

References:

Sofort Banking Casino Sofort Casino Erfahrungen

回复

Sofortüberweisung Auszahlung Casino · 2026-09-23 00:49

References:

Casino ohne anmeldung sofort Sofortüberweisung Auszahlung Casino

回复

https://bbs.kxwh.cn/home.php?mod=space&uid=417269 · 2026-09-23 04:48

References:

Online casino echtgeld sofortüberweisung https://bbs.kxwh.cn/home.php?mod=space&uid=417269

回复

http://bbs.88moli.top · 2026-09-23 07:10

References:

Bezahlen mit sofort casino http://bbs.88moli.top/home.php?mod=space&uid=128706

回复

http://gjglm.com/ · 2026-09-23 07:21

References:

Casino ohne Anmeldung Sofortüberweisung http://gjglm.com/home.php?mod=space&uid=189044

回复

https://bbs.darkml.net/ · 2026-09-23 15:51

References:

Sofortüberweisung casino bonus https://bbs.darkml.net/home.php?mod=space&uid=285535

回复

Sofort Casino schnelle Auszahlung · 2026-09-24 02:19

References:

Online casino sofort ohne oasis https://bbs.darkml.net/home.php?mod=space&uid=285402

回复

happybingoapp · 2026-09-25 20:00

As a busy parent, I finally found time to try this. The secure payment options like GCash are perfect for quick sessions. You can grab the Happybingo App download now and enjoy safe Filipino gaming without long waits or complicated steps today.

回复

https://topsitenet.com · 2026-09-25 20:42

References:

Fast withdrawal pokies australia payid https://topsitenet.com/profile/temposelect3/2529659/

回复

sporeus.com · 2026-09-26 03:10

References:

Pokies payid instant https://www.sporeus.com/author/farmerstage15/

回复

https://www.hobbycuenca.com/ · 2026-09-26 16:42

References:

Australian online casino payid pokies https://www.hobbycuenca.com/cups-c/

回复

http://bbs.4d-host.net · 2026-09-27 01:38

References:

Same day payout pokies payid http://bbs.4d-host.net/thread-50619-1-1.html

回复

jl36 · 2026-09-27 08:37

I’m always hunting for secure gaming tools; jl36’s provably fair tech and local payment options look solid. Check out jl36 app download apk to try their decentralized security protocols today.

回复

payid deposit online pokies · 2026-09-28 20:56

References:

1 minimum deposit casino australia payid https://test-sida.noads.biz/?477188

回复

payid pokies real money · 2026-09-29 00:29

References:

10 dollar deposit pokies payid https://hedgedoc.dezentrale.space/GnQOkQWfT8WqILq7gtRtag

回复

australian pokies that accept payid · 2026-09-29 05:07

References:

Free spins payid pokies australia https://onlinevetjobs.com/author/jokeafrica06/

回复

minimum deposit payid pokies · 2026-09-29 08:38

References:

1 dollar deposit pokies payid https://md.interhacker.space/_cxVX4R4TcW1uFBjFpDHcQ

回复

10 minimum deposit online casino neosurf · 2026-10-03 23:54

References:

Neosurf trusted casinos australia https://www.8njy.com/home.php?mod=space&uid=159553

回复

https://chuangu.xyz/ · 2026-10-04 07:32

References:

Neosurf casino instant deposit australia https://chuangu.xyz/home.php?mod=space&uid=328109&do=profile&mycenter=1

回复

https://hedgedoc.uni-ak.ac.at · 2026-10-04 12:56

References:

Online pokies that accept payid https://hedgedoc.uni-ak.ac.at/QKXVL6VcQ9GBZvO85E27KQ

回复

actualites.cava.tn · 2026-10-04 17:26

References:

Neosurf casino tips australia https://actualites.cava.tn/user/kaleowl7/

回复

neosurf prepaid card casino australia · 2026-10-06 03:35

References:

Best neosurf casinos australia https://manualshyundai.com/user/parentsandra3/

回复

https://aryba.kg/user/diggercrocus43/ · 2026-10-06 05:08

References:

Neosurf casino free spins australia https://aryba.kg/user/diggercrocus43/

回复

https://test-sida.noads.biz/?493680 · 2026-10-06 07:16

References:

Play pokies with neosurf https://test-sida.noads.biz/?493680

回复

neosurf casino no id australia · 2026-10-06 10:01

References:

Australian online pokies neosurf https://guzhen0552.cn/home.php?mod=space&uid=2543225

回复

https://vlauncher.net/ · 2026-10-06 13:03

References:

Neosurf welcome bonus casino australia https://vlauncher.net/user/dewtrick5/

回复

phcity · 2026-10-10 08:56

Honestly, reading about the classic feel of phcity online casino reminds me of simpler times! The focus on steady rhythm is key; I’m tired of chaotic interfaces. Hope this helps other busy parents too!

回复

chesswiki.site · 2026-10-16 04:45

References:

Wire transfer casino welcome bonus https://chesswiki.site/wiki/Wire_Transfers_Casinos_Top_Casino_Banking_Method

回复

osko casino 2026 · 2026-10-16 13:25

References:

How to deposit with osko at a casino https://text.dsf.hs-heilbronn.de/ncMrJs2BTaari63VMpjjBA

回复

http://www.lezcc.com/?645622 · 2026-10-16 22:09

References:

Online casino muchbetter http://www.lezcc.com/?645622

回复

http://gjglm.com/home.php?mod=space&uid=237363 · 2026-10-17 02:17

References:

Bank transfer mobile pokies australia http://gjglm.com/home.php?mod=space&uid=237363

回复

gb99 · 2026-10-17 18:28

[9634]gb99 login করুন | বিকাশ দিয়ে অনলাইন স্লট ও রুলেট খেলুন,gb99 app download করে আজই যোগ দিন। বিকাশ দিয়ে অনলাইন ক্যাসিনো গেম খেলুন এবং অনলাইন রুলেট খেলার নিয়ম জেনে জিতে নিন। এখনই সাইন আপ করুন। visit: gb99

回复

53abet · 2026-10-17 21:06

Was looking for a new spot to play, and came across 53abet. Haven’t deposited anything yet, but the game variety seems pretty solid. Gonna do some more digging before I commit.

回复

winnipegasians.com · 2026-10-18 07:05

References:

BPay pokies registration https://winnipegasians.com/home.php?mod=space&uid=264468

回复

pokies that accept MiFinity · 2026-10-18 15:35

References:

Top rated MiFinity casinos Australia http://t.044300.net/home.php?mod=space&uid=3190647

回复

https://27vlz.ru/user/shockstream69/ · 2026-10-19 06:22

References:

Neosurf casino poker machines australia https://27vlz.ru/user/shockstream69/

回复

neosurf minimum deposit pokies australia · 2026-10-19 10:23

References:

Neosurf jackpot pokies australia https://xbymw.com/space-uid-1369576.html

回复

xgamesapk · 2026-10-20 06:26

Finally found something useful! The platform details look solid, especially the focus on skill-building. Checking out XGames APK vip next. Seems like a good resource for more than just slots.

回复

https://www.forum.uookle.com · 2026-10-20 09:15

References:

Highest paying payid pokies australia https://www.forum.uookle.com/home.php?mod=space&uid=1839915

回复

supergame.one · 2026-10-20 12:19

References:

Top osko casino sites http://www.supergame.one/home.php?mod=space&uid=2721733

回复

http://pandora6666.com · 2026-10-20 22:14

References:

Instant withdrawal pokies Osko http://pandora6666.com/?231097

回复

fast withdrawal pokies australia payid · 2026-10-21 03:53

References:

Trusted payid pokies australia http://www.pshunv.com/space-uid-1049097.html

回复

发表回复

Avatar placeholder

您的邮箱地址不会被公开。 必填项已用 * 标注

相关文章

ClickHouse生态 大数据

ClickHouse学习笔记十管理与运维

介绍 ClickHouse 管理与运维相关的知识：权限、熔断机制、数据 阅读更多…

ClickHouse生态 大数据

ClickHouse学习笔记九副本与分片

集群是副本和分片的基础。副本防止数据丢失（冗余存储），分片实现数据水平 阅读更多…

ClickHouse生态 大数据

ClickHouse学习笔记八数据查询

作为一款 OLAP 分析型数据库，数据查询是 ClickHouse 的 阅读更多…