Now()
Now() 함수는 컴퓨터의 시스템 날짜와 시간을 기준으로 현재 날짜와 시간을 반환한다.
Access 2000에서 작동한다.
형식
Now()
예제
컴퓨터 시스템의 현재 날짜와 시간을 반환해보자.
SELECT CustomerName, Now() AS CurrentDateTime FROM Customers;
기본 예시
| CustomerName | CurrentDateTime |
|---|---|
| Alfreds Futterkiste | 9/29/2023 3:11:03 AM |
| Ana Trujillo Emparedados y helados | 9/29/2023 3:11:03 AM |
| Antonio Moreno Taquería | 9/29/2023 3:11:03 AM |
| Around the Horn | 9/29/2023 3:11:03 AM |
| Berglunds snabbköp | 9/29/2023 3:11:03 AM |
| Blauer See Delikatessen | 9/29/2023 3:11:03 AM |
| Blondel père et fils | 9/29/2023 3:11:03 AM |
| Bólido Comidas preparadas | 9/29/2023 3:11:03 AM |
| Bon app’ | 9/29/2023 3:11:03 AM |
| Bottom-Dollar Marketse | 9/29/2023 3:11:03 AM |
| B’s Beverages | 9/29/2023 3:11:03 AM |
| Cactus Comidas para llevar | 9/29/2023 3:11:03 AM |
| Centro comercial Moctezuma | 9/29/2023 3:11:03 AM |
| Chop-suey Chinese | 9/29/2023 3:11:03 AM |
| Comércio Mineiro | 9/29/2023 3:11:03 AM |
| Consolidated Holdings | 9/29/2023 3:11:03 AM |
| Drachenblut Delikatessend | 9/29/2023 3:11:03 AM |
| Du monde entier | 9/29/2023 3:11:03 AM |
| Eastern Connection | 9/29/2023 3:11:03 AM |
| Ernst Handel | 9/29/2023 3:11:03 AM |
| Familia Arquibaldo | 9/29/2023 3:11:03 AM |
| FISSA Fabrica Inter. Salchichas S.A. | 9/29/2023 3:11:03 AM |
| Folies gourmandes | 9/29/2023 3:11:03 AM |
| Folk och fä HB | 9/29/2023 3:11:03 AM |
| Frankenversand | 9/29/2023 3:11:03 AM |
| France restauration | 9/29/2023 3:11:03 AM |
| Franchi S.p.A. | 9/29/2023 3:11:03 AM |
| Furia Bacalhau e Frutos do Mar | 9/29/2023 3:11:03 AM |
| Galería del gastrónomo | 9/29/2023 3:11:03 AM |
| Godos Cocina Típica | 9/29/2023 3:11:03 AM |
| Gourmet Lanchonetes | 9/29/2023 3:11:03 AM |
| Great Lakes Food Market | 9/29/2023 3:11:03 AM |
| GROSELLA-Restaurante | 9/29/2023 3:11:03 AM |
| Hanari Carnes | 9/29/2023 3:11:03 AM |
| HILARIÓN-Abastos | 9/29/2023 3:11:03 AM |
| Hungry Coyote Import Store | 9/29/2023 3:11:03 AM |
| Hungry Owl All-Night Grocers | 9/29/2023 3:11:03 AM |
| Island Trading | 9/29/2023 3:11:03 AM |
| Königlich Essen | 9/29/2023 3:11:03 AM |
| La corne d’abondance | 9/29/2023 3:11:03 AM |
| La maison d’Asie | 9/29/2023 3:11:03 AM |
| Laughing Bacchus Wine Cellars | 9/29/2023 3:11:03 AM |
| Lazy K Kountry Store | 9/29/2023 3:11:03 AM |
| Lehmanns Marktstand | 9/29/2023 3:11:03 AM |
| Let’s Stop N Shop | 9/29/2023 3:11:03 AM |
| LILA-Supermercado | 9/29/2023 3:11:03 AM |
| LINO-Delicateses | 9/29/2023 3:11:03 AM |
| Lonesome Pine Restaurant | 9/29/2023 3:11:03 AM |
| Magazzini Alimentari Riuniti | 9/29/2023 3:11:03 AM |
| Maison Dewey | 9/29/2023 3:11:03 AM |
| Mère Paillarde | 9/29/2023 3:11:03 AM |
| Morgenstern Gesundkost | 9/29/2023 3:11:03 AM |
| North/South | 9/29/2023 3:11:03 AM |
| Océano Atlántico Ltda. | 9/29/2023 3:11:03 AM |
| Old World Delicatessen | 9/29/2023 3:11:03 AM |
| Ottilies Käseladen | 9/29/2023 3:11:03 AM |
| Paris spécialités | 9/29/2023 3:11:03 AM |
| Pericles Comidas clásicas | 9/29/2023 3:11:03 AM |
| Piccolo und mehr | 9/29/2023 3:11:03 AM |
| Princesa Isabel Vinhoss | 9/29/2023 3:11:03 AM |
| Que Delícia | 9/29/2023 3:11:03 AM |
| Queen Cozinha | 9/29/2023 3:11:03 AM |
| QUICK-Stop | 9/29/2023 3:11:03 AM |
| Rancho grande | 9/29/2023 3:11:03 AM |
| Rattlesnake Canyon Grocery | 9/29/2023 3:11:03 AM |
| Reggiani Caseifici | 9/29/2023 3:11:03 AM |
| Ricardo Adocicados | 9/29/2023 3:11:03 AM |
| Richter Supermarkt | 9/29/2023 3:11:03 AM |
| Romero y tomillo | 9/29/2023 3:11:03 AM |
| Santé Gourmet | 9/29/2023 3:11:03 AM |
| Save-a-lot Markets | 9/29/2023 3:11:03 AM |
| Seven Seas Imports | 9/29/2023 3:11:03 AM |
| Simons bistro | 9/29/2023 3:11:03 AM |
| Spécialités du monde | 9/29/2023 3:11:03 AM |
| Split Rail Beer & Ale | 9/29/2023 3:11:03 AM |
| Suprêmes délices | 9/29/2023 3:11:03 AM |
| The Big Cheese | 9/29/2023 3:11:03 AM |
| The Cracker Box | 9/29/2023 3:11:03 AM |
| Toms Spezialitäten | 9/29/2023 3:11:03 AM |
| Tortuga Restaurante | 9/29/2023 3:11:03 AM |
| Tradição Hipermercados | 9/29/2023 3:11:03 AM |
| Trail’s Head Gourmet Provisioners | 9/29/2023 3:11:03 AM |
| Vaffeljernet | 9/29/2023 3:11:03 AM |
| Victuailles en stock | 9/29/2023 3:11:03 AM |
| Vins et alcools Chevalier | 9/29/2023 3:11:03 AM |
| Die Wandernde Kuh | 9/29/2023 3:11:03 AM |
| Wartian Herkku | 9/29/2023 3:11:03 AM |
| Wellington Importadora | 9/29/2023 3:11:03 AM |
| White Clover Markets | 9/29/2023 3:11:03 AM |
| Wilman Kala | 9/29/2023 3:11:03 AM |
| Wolski | 9/29/2023 3:11:03 AM |
참고
W3C School - SQL Now() Function
W3C School - SQL Tutorial
공부 목적 블로그