Re: SQL Q: how to select current time?

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: 1998/08/26
Message-ID: <35e4809f.160432830@news.cyberus.ca>#1/1

"Dave Cooper" <dave_at_dpc-c.demon.co.uk> wrote:

>Look at formatting date type columns in your SQL guide. The sysdate does
>have the time embedded in it but by default is not displayed. You need to
>apply a format mask to sysdate to extract the date and time.
>
>m_van_basten_at_hotmail.com wrote in article
><6rshag$khf$1_at_nnrp1.dejanews.com>...
>> Selecting SysDate from dual only gives the date. So how to select
 current
>> time? And how to select date and time together?
>>
>> Thanks!
>>
>> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
>> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>>

example:

SQL> select to_char(sysdate,'hh24:ss:mi') from dual;

TO_CHAR(

---

17:12:39

SQL> select to_char(sysdate,'ddmmyyyy hh24:ss:mi') from dual;

TO_CHAR(SYSDATE,'

---

26081998 17:31:39

#****************************************************
#	RP Data Solutions Inc.
#	Specializing in ORACLE DBA Support Services
#       We offer 24HR remote DBA support!!!
#****************************************************

Received on Wed Aug 26 1998 - 00:00:00 CDT