Member Avatar for stefilina

Can anybody please explain me this expression?
CONVERT(datetime, CONVERT(varchar, GETDATE(), 1)

thanks.

  • 2 Contributors
  • 2 Replies
  • 127 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by abelLazm
Member Avatar for abelLazm

This is the command which first convert current date time into varchar then the result is again converted to datetime datatype.

Member Avatar for abelLazm

This is the command which first convert current date time into varchar then the result is again converted to datetime datatype.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.