| |

VerySource

 Forgot password?
 Register
Search
View: 7|Reply: 4

Query data. Use time as a filter condition. The condition is incorrect.

[Copy link]

2

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-3-15 18:00:01
| Show all posts |Read mode
select * from t_inout_all where
to_char (createtime, 'yyyy-mm-dd hh: mm: ss') = '2016-11-28 17:50:00'


createtime is a DATE type
Reply

Use magic Report

0

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-6-14 22:15:01
| Show all posts
select* from t_inout_all where
to_char(createtime,'yyyy-mm-dd hh24:mm:ss') ='2016-11-28 17:50:00'
Reply

Use magic Report

0

Threads

39

Posts

23

Credits

Newbie

Rank: 1

Credits
23

 China

Post time: 2020-6-16 22:15:01
| Show all posts
select * from t_inout_all where
to_char(createtime,'yyyy-mm-dd hh24:mi:ss') ='2016-11-28 17:50:00'
Reply

Use magic Report

0

Threads

39

Posts

23

Credits

Newbie

Rank: 1

Credits
23

 China

Post time: 2020-6-17 18:45:02
| Show all posts
mm month
mi points
Reply

Use magic Report

0

Threads

68

Posts

47

Credits

Newbie

Rank: 1

Credits
47

 China

Post time: 2020-6-17 20:00:01
| Show all posts
select * from t_inout_all where to_char(createtime,'yyyy-mm-dd hh24:mi:ss') ='2016-11-28 17:50:00'

hh is divided into hh24 and hh12
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list