Member Avatar for ali.alipanahi

hi friend's i have a problem in reporting according to the date i have to save the date in a navarchar format in sql table but i dont know how to define my date and how can i make a
Reporting period based on pleasee help meeeee pleasssssssssssssssssssss:(

  • 2 Contributors
  • 1 Reply
  • 67 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Mitja Bonca
Member Avatar for Mitja Bonca

With Microsoft Sql Server:

--
-- Create test case
--
DECLARE @myDateTime DATETIME
SET @myDateTime = '2008-05-03'

--
-- Convert string
--
SELECT LEFT(CONVERT(VARCHAR, @myDateTime, 120), 10)

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.