Different results - SQL Server and PHP (PEAR DB)

Question

I'm trying to run a query using php pear db and is not returning any value. However, when I run using SQL Server I get the data

In PHP I'm already setting:

"SET ANSI_NULLS ON" and "SET ANSI_WARNINGS ON"

Query:

select A.nome, count(sa.id_sala) as Atendimentos, cast( avg( case when (coalesce(sa.dt_final, sa.dt_ping_internauta) > sa.dt_inicio_atendimento) then datediff(minute, coalesce(sa.dt_inicio_atendimento, sa.dt_inicio), coalesce(sa.dt_finalAtendimento, coalesce(sa.dt_final, sa.dt_ping_internauta)) ) else 0 end ) as money) as [media em minutos] from sala SA join atendente A on (A.id_atendente = SA.fk_id_atendente) where sa.interno = 0 and coalesce(sa.dt_inicio_atendimento, sa.dt_inicio) between '2012-01-01' and '2012-12-31' and SA.fk_id_empresa = 1 group by A.nome order by 2 desc

SOLVED

solution:

"The safe datetime string formats to use in SQL Server is

YYYYMMDD HH:MM:SS or YYYY-MM-DDTHH:MM:SS."

SQL Error : The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

Please add your solution as answer.

cweiske
– cweiske

2013-07-08 09:09:19 +00:00
Commented Jul 8, 2013 at 9:09 — cweiske
– cweiske, Commented Jul 8, 2013 at 9:09

Community · Accepted Answer · 2017-05-23 10:30:45Z

2

SOLVED

solution:

"The safe datetime string formats to use in SQL Server is

YYYYMMDD HH:MM:SS or YYYY-MM-DDTHH:MM:SS."

SQL Error : The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Jul 9, 2013 at 15:21

E. S.

2,91920 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Different results - SQL Server and PHP (PEAR DB)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related