Home > database >  Novice advice on how to delete the hourly time data
Novice advice on how to delete the hourly time data

Time:10-03

Delete the black circle data need to keep other black box blank

CodePudding user response:

(h hour) when the date comes out, and then die 30, in addition to clean is the hour,
The delete from xytab1
Where DatePart (" h ", recordtime) mod 30=0
  • Related