Re: SQL Q: how to select current time?

From: Dave Cooper <dave_at_dpc-c.demon.co.uk>
Date: 1998/08/26
Message-ID: <01bdd117$38f25320$8de1edc1@dpc-c>#1/1

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
>
Received on Wed Aug 26 1998 - 00:00:00 CDT