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

Creating an invoice
Using fpdf I am trying to create an invoice to send to clients. The products are sold in pricing tie

First root of a number
Hi,

I can't find any function in php to give me the first root of a number.
Is there any

listing help
Hi,

at first, great new design!!! I like it,

i got a problem,

I want to list so

Ignore html and bbcode?
I've created a function to limit the amount of text according to the amount of words.

However

Load file in PHP
I have 2 files. The first is a PHP generated XML file that's dependent by 2 inputs. The second is a

PL/SQL: ORA-00947: not enough values error message
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing

user data not transferring to new page
I'm a PHP learner. After an index.php page, the user goes to a login.php page. Both pages seem to

Registration
ok so i have a site where people can register and login which works now thanks to someone on here th

MASS PM
Hello all, I'm trying to send mass private messages to users in my database but keep getting an erro

IDOC error
Hi, When i send IDOC from ECC system to MII there is no problem ECC side, i says message sent succe