, ['Created_at', '<', Time ()-$ H*3600]

[tig3306]

What steps will reproduce the problem?

What is the expected result?

The comparative operator should be placed in the middle or it will become very detouring
For example, ['Created_at', '<', Time ()-$ H*3600]
It should be more likely to change this like a mathematical formula

What do you get instead?

Additional info

Q	A
Version	1.0.?
PHP version
Operating system

[xepozz]

->where('Created_at <' . Time()-$H*3600)

Here you can use it instead.

I'm not sure the position of the operator would change.

[vjik]

Cycle ORM used this order. What about other ORM / DB abstractions?

[Tigrov]

Usially it is [operator, column name, value]
For example, ['<', 'Created_at', time() - $H*3600]

The documentation
https://github.com/yiisoft/db/blob/master/docs/guide/en/query/where.md

[samdark]

The reason for current operator-parameters is that there are such operators as not where the format proposed doesn't fit. Current schema works for any operator but is, indeed, is not very natural.

[tig3306]

I've already fixed it myself You guys don't use this kind of work Too tongue-twisting I hope to change it to the same as a normal mathematical formula It's more convenient

Usially it is [operator, column name, value] For example, ['<', 'Created_at', time() - $H*3600]

The documentation https://github.com/yiisoft/db/blob/master/docs/guide/en/query/where.md

I've already fixed it myself You guys don't use this kind of work Too tongue-twisting I hope to change it to the same as a normal mathematical formula It's more convenient

[tig3306]

->where('Created_at <' . Time()-$H*3600)

Here you can use it instead.

I'm not sure the position of the operator would change.

I'm more repulsive to the string pattern It's easy to make mistakes Because the IDE tool is not compatible with strings I don't recommend that way of writing

[tig3306]

The reason for current operator-parameters is that there are such operators as not where the format proposed doesn't fit. Current schema works for any operator but is, indeed, is not very natural.

We've grown up with mathematical formulas a-b=c mode You're not used to writing like that

[tig3306]

Usially it is [operator, column name, value] For example, ['<', 'Created_at', time() - $H*3600]

The documentation https://github.com/yiisoft/db/blob/master/docs/guide/en/query/where.md

We've grown up with mathematical formulas a-b=c mode You're not used to writing like that

[samdark]

Sure, I understand that this format isn't natural to what anyone's used to, but how to deal with, for example, the following?

['and', 'sum>10', '!is_deleted', 'is_active']