■ CURRENT_TIMESTAMP 키워드를 사용해 현재 시각을 구하는 방법을 보여준다.
▶ 예제 코드 (SQL)
|
1 2 3 4 5 6 7 |
SELECT CURRENT_TIMESTAMP; /* 2023-06-30 23:00:49.546756+09 */ |
[DATABASE/POSTGRESQL] CURRENT_TIMESTAMP 키워드 : 현재 시각 구하기
icodebroker
POSTGRESQL
2024-06-18
분류
- PROGRAMMING (15,133)
- ARDUINO (16)
- C# (10,814)
- .NETSTANDARD (5)
- ASP.NET (123)
- ASP.NET MVC (283)
- COMMON (2,210)
- ADVANCED INSTALLER (5)
- AKKA.NET (3)
- AUDIOSWITCHER (5)
- AVROCONVERT (6)
- AZURE (1)
- CSVHELPER (4)
- DAPPER (16)
- DEVEXPRESS (8)
- DOCKER (2)
- FLUENTFTP (2)
- GCLOUD (2)
- GRPC (3)
- HTMLAGILITYPACK (3)
- IBATIS (3)
- LINQ (9)
- MAILKIT (2)
- MESSAGEPACK (2)
- MICROSOFT (1,804)
- ML.NET (1)
- NATS (4)
- NAUDIO (47)
- NEWTONSOFT (4)
- NLOG (3)
- NMEMORY (18)
- NUNIT (7)
- OPENPOP (15)
- OPENXML (1)
- ORACLE (2)
- OUTLOOK (83)
- POSTGRESQL (1)
- PROTO.ACTOR (16)
- PROTOBUF (2)
- R.NET (6)
- RABBITMQ (6)
- REACT (2)
- REDIS (27)
- SELENIUM (44)
- SHARPDX (5)
- SQLITE (18)
- WORDPRESS (10)
- YOUTUBE (6)
- ZEROFORMATTER (2)
- LINQ (104)
- MAUI (934)
- ML.NET (8)
- SILVERLIGHT (215)
- TPL (102)
- UNO (2)
- UWP (349)
- WCF (65)
- WEB API (24)
- WIN32 (238)
- WINFORM (3,143)
- WINUI3 (226)
- WPF (2,782)
- XAMARIN (1)
- CLOUD (148)
- CODE (3)
- CSS (10)
- DART (96)
- DATABASE (734)
- DOCKER (120)
- ERLANG (1)
- FFMPEG (17)
- FLUTTER (91)
- GIT (20)
- HADOOP (1)
- HTML (27)
- JAVASCRIPT (80)
- NATS (11)
- OS (233)
- POWERSHELL (231)
- PYTHON (1,862)
- AIOFILES (5)
- BEANIE (2)
- CHARDET (1)
- COMMON (1,036)
- COVERAGE (1)
- CX_ORACLE (1)
- FASTAPI (22)
- FLASK (1)
- GOOGLE (2)
- HTTPX (16)
- JINJA2 (4)
- JS2PY (1)
- KERAS (23)
- KOREAN_LUNAR_CALENDAR (6)
- LANGCHAIN (371)
- LLAMA-INDEX (16)
- MATPLOTLIB (12)
- NEST_ASYNCIO (1)
- NLTK (4)
- NUMPY (39)
- OLLAMA (2)
- OPENAI (24)
- OPENCV (23)
- PANDAS (12)
- PILLOW (14)
- PSYCOPG2 (14)
- PYDANTIC (6)
- PYDUB (1)
- PYINSTALLER (3)
- PYKRX (24)
- PYMONGO (20)
- PYPERCLIP (2)
- PYSQLITE (23)
- PYTEST (3)
- PYTZ (3)
- REQUESTS (4)
- SCHEDULE (1)
- SENTENCE-TRANSFROMERS (1)
- SKIMAGE (22)
- SKLEARN (8)
- SQLMODEL (8)
- STREAMLIT (18)
- TENSORFLOW (51)
- TIKTOKEN (7)
- TRANSFORMERS (1)
- UVICORN (3)
- R (74)
- RABBITMQ (6)
- RUST (293)
- TOOL (72)
- VB (164)
- VBA (2)
- VUE.JS (2)
- WEB (5)
- SOFTWARE (2)
- 사전 (731)
가장 많이 읽힌 글
.NET6 .NETCORE .NETFRAMEWORK 2D AI ANIMATION ASP.NET MVC C# CHART COLLECTION COMMON CONCURRENCY CONTROL DATA DATABASE DATE DEVEXPRESS DOCUMENT EDITOR FILE GRAPHICS GRID IMAGE LANGCHAIN LLM MATH MAUI MICROSOFT NETWORK OPENAI ORACLE OS POWERSHELL PYTHON RUST SCOTTPLOT STRING SYSTEM TEECHART UWP WIN32 WINDOWS WINFORM WINUI3 WPF