使用groovy解析sql日期列

import java.util.Date
import java.text.SimpleDateFormat

def dateFormat = new SimpleDateFormat("yyyy-MM-dd")

def dateString = "2022-01-01"
def date = dateFormat.parse(dateString)

import java.util.Date
import java.text.SimpleDateFormat

def dateFormat = new SimpleDateFormat("yyyy-MM-dd")
def dateString = "2022-01-01"
def date = dateFormat.parse(dateString)

// 日期格式化
def formattedDate = dateFormat.format(date)
println("Formatted Date: ${formattedDate}")

// 日期比较
def currentDate = new Date()
if (date.before(currentDate)) {
  println("Date is before current date")
} else if (date.after(currentDate)) {
  println("Date is after current date")
} else {
  println("Date is equal to current date")
}

// 日期加减
def calendar = Calendar.getInstance()
calendar.setTime(date)
calendar.add(Calendar.DAY_OF_MONTH, 7)
def newDate = calendar.getTime()
println("New Date: ${dateFormat.format(newDate)}")