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

Multiple forms on the same page (safari)
Hello everyone,

I have 3 forms on the same page, that opens in a new window and submits to a

Batch Related Pricing
Hi, I need some clarity on the batch related pricing

For example the following are the b

I need help on this PHP code
Hi everybody, I made some kind of mistake while editing the code below. As you see, at the 3 row my

Retreiving objects from Sessions
Hi all,

I am getting really frustrated with storing and retreiving objects from a session. Bu

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

Multipe Dynamic Controls & AutoPostback Issue
I currently have a need to create many dynamic controls (Example Textboxes) that need to do a PostBa

getting most records by count
Code: [Select]<?php

$connect = mysql_connect("localhost","dam

Code Help.. If txt input box empty search X instead..
I am having a problem with my search script. At current it will simply search by a selected date whi

FTP issues
Hi all,


I am currently facing some serious problems with a script and really need some ad

check if value exists
I have googled this for a while and I am getting lots of different results. Is there a standard meth