Formatting an MS SQL Server date in PHP

Question

I have several HTML date fields that are formatted like this:

<?php echo date('m/d/Y', strtotime($row['Date1'])); ?>

This works fine as long as a value exists in the database for Date1; however, if the value is NULL or blank in the DB, then I get 12/31/1969 in my field. This is obviously undesirable. I would like the field to be empty if there is no value in the DB. I've tried converting the date in the original SELECT query, like this:

SELECT CONVERT(varchar, Date1, 101) FROM table;

to no avail. I have also tried the functions date() and strtotime() by themselves, but they both throw errors.

The data type in the database is "date" and it is set to accept NULLs. There is currently no default value. How can I prevent this false date from appearing?

Iłya Bursov · Accepted Answer · 2013-12-13 02:58:26Z

1

even if there are correct answer, you can try another variant:

SELECT ISNULL(CONVERT(varchar, Date1, 101), '') FROM table;

answered Dec 13, 2013 at 2:58

Iłya Bursov

24.4k4 gold badges36 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user557846 · Accepted Answer · 2013-12-12 21:23:18Z

0

check its not empty first

if( !empty($row['Date1']){
    //echo date('m/d/Y', strtotime($row['Date1']));
    $db_date=date('m/d/Y', strtotime($row['Date1']))
}else{
    $db_date='';
}

answered Dec 12, 2013 at 21:23

user557846

Collectives™ on Stack Overflow

Formatting an MS SQL Server date in PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related