mysql date-format returns null

Question

I have the following SQL query. It returns NULL for the 'invoice_date'.

SELECT * , fk_uid AS userId, fk_ivid AS invoice_uid, (

SELECT company
FROM tbl_users
WHERE pk_uid = userId
) AS invoice_customer, (

SELECT DATE_FORMAT( '%d/%m/%y', purchased ) AS invoice_date
FROM _invoices
WHERE invoice_uid = invoice_uid
LIMIT 1
) AS invoice_date
FROM tbl_statement_items
WHERE statement_generated = '1'
AND fk_statementId = '1'
LIMIT 0 , 30

Any help would be appriciated.

Thanks

Simon · Accepted Answer · 2011-04-26 15:40:07Z

3

You have inverted date_format parameters order.

edited Apr 26, 2011 at 15:40

Simon

2,00815 silver badges21 bronze badges

answered Apr 26, 2011 at 15:38

Nicola Cossu

56.7k15 gold badges96 silver badges99 bronze badges

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

1 Comment

Kyle Hudson Over a year ago

Thanks it didn't throw any errors when i rabn it +1, can't accept your answer for 6 mins :P

Collectives™ on Stack Overflow

mysql date-format returns null

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related