Help on query replacing the date

Posted on 16th Feb 2014 07:03 pm by admin

Hi Pals,

i want to replace the current date in a column to some value say C or D or any numeric value , likewise the NVL function which replaces the null value can i replace value selected to my assigned value
eg

select * from employee where employeedate= current dat will display the dates as 2008-10-10 to C or D

Your Answer:

Login to answer

Other forums

Force download script not handling files with spaces properly
I have a regular old php force download script, uses this code:

Code: header("Cache-Cont

Frustrated php Newbie
First off, I am pretty much a PHP nub. I can read and understand the language (most of the time) so

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

HTML Viewer HIDE scrollbar
How can I disable scrollbars in a HTML Viewer control? I can't hide them. Even i have enough space b

Most basic form question ever?
Hello,

I want to use this snippet to make sure the fields in a form are ok before processing

Multiple websites question.
Hi, does php have any functionality that enables a programmer to extract information from a website

PHP Error
On my .php page I have a drop down box that has several names in it. When a user clicks the name &am

Multiple PHP errors when clicking a link..and..removing a ghost..
Hi - I have 2 problems with a new website - homeswapvacations.com, which I need help solving.

ALV grid with 2 headers
Hi Gurus,

I need to display ALV GRID as below.

Header1

Java API in PHP?
I have an application that we use internally here at the office.

The software company provide