[RESOLVED] SQL Server - Returning Date Value

obrienkev

// process date **********************************
$closed_date = date("d/m/Y" ,strtotime($row['closed_date']));
echo '<h1>'.$closed_date.'</h1>';

closed_date is set in the database as smalldatetime. Also given NULL value.

If the field is NULL today's date is returned. Why is this?

If the field is NULL I want a blank value displayed.

How is this done? Working on MS SQL Server.

Thanks.

Shrike

You get today's date because that's the default behaviour for strtotime when it gets a null argument. Same goes for date as it happens.

strtotime manual page wrote:
The function expects to be given a string containing a US English date format and will try to parse that format into a Unix timestamp (the number of seconds since January 1 1970 00:00:00 GMT), relative to the timestamp given in now, or the current time if none is supplied.

obrienkev

So how can I solve this?

obrienkev

Sorry to bump this but still no resolution on the subject.

Is there anything I can change? If the date textfield is blank, then the db field is NULL.
Then on displaying the data from the database today's date is displayed.

I just want no value returned for a null.

thanks

jheitz

Why not check if $row['closed_date'] has returned a NULL with an if statement? If a NULL has been returned then set your variable to "" or whatever you want...

obrienkev

Of Course! :o

Thanks! That's great.

Removed the NULL from DB fields.

// process date **********************************
if(isset($closed_date) && $closed_date != '')
{
list($day, $month, $year) = split('[/.-]', $closed_date);
//echo "Day: $day; Month: $month; Year: $year<br />\n";
$closed_date = $year.'-'.$month.'-'.$day;
}
else {
		 $closed_date = '';
}