Solving LIKE problems online

nowayer

A field in the ACCESS database is a date type, and stores the complete time, including year, month, day, hour, minute, and second.
When searching, I need to find the records that meet the conditions, how should I use LIKE?

yflovefly

select * from tablename where ddate between # 2017-1-1 00: 00: 01 # and # 2017-1-4 23: 59: 59 #

wufuyi

You can convert the date type into a fixed format string in SQL query, so that you can query not only a certain day, but also a certain year, a month, a certain time, a certain second, because I have been programming under SQLServer2000 , I don't know the SQL functions related to ACCESS, please also masters to give these functions
    Write this in SQL Server 2000:
    select * from table name where convert (char (10), date field, 120) = '2017-01-05'

restajufehyg

format for access:

select * from tb
where format (youDate, "yyyy-mm") = '2016-12'

restajufehyg

format for access:

select * from tb
where format (youDate, "yyyy-mm-dd") = '2016-12-25'

nowayer

restajufehyg

According to your wording, the prompt type does not match, is it because there is a null value in the date field?

wufuyi

Conditions can be added:
 and not date field is null

nowayer

I wrote it this way. I beg your boss to see what went wrong.

RS.Open "select * from TB1 where" + Format ([D_Field], "yyyy-mm-dd") + "= '" + Format (Now, "yyyy-mm-dd") + "'", CN, adOpenDynamic, adLockBatchOptimistic

wufuyi

RS.Open "select * from TB1 where Format([D_Field],'yyyy-mm-dd') ='" + Format(Now, "yyyy-mm-dd") + "'", CN, adOpenDynamic, adLockBatchOptimistic

This should be right, because I don't have ACCESS, so I can't debug, but I see the basic problems when you write

nowayer

Problem solving, thank you teachers.