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

Problems with strings containing
Hey all,

I have encountered something strange in a script. I am trying to write an XML heade

Need help with an email blocker for a guessbook
I am new with php and here is a simple guessbook page but I am being hit with spam from a group of t

MySQL Primary key gap
Alright, so I have a table with 26 entries in it (id, filename, caption) for my image randomiser (ht

Why does my php page download images over and over
Can anybody please explain to me why my php page keeps downloading the images and other items every

highlighting search terms
well, I started this in the regular PHP section, but it no longer fits there. Suffice it to say, I'm

onclick problem
I have <input type="text" name="message">
<a href=page2.

post to self
Trying to get my form to submit to itself. However I am also trying to use an image for my submit bu

ereg_replace in Wordpress
Heya - so I'm working on this site: http://world-of-smiles.theportlandco.com/new-patients

The

xml
<?php

echo "<h1>XML Articles</h1>";

$home

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde