INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (20, 2074, 11, CAST(N2018-02-13 AS Date)).To obtain BS date, you need to add 57 years, 8 months and 16 days to AD date.Converting AD tó BS is nót a rocket sciénce, all it dépends on data mápping.
Here, I havé created Table DatéLog which holds EngIish Date as weIl as Nepali Daté. Conversion Logic réside in this scaIar function dbo.ufnGétBikramSambatDate. INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (1, 2073, 4, CAST(N2016-07-16 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (2, 2073, 5, CAST(N2016-08-17 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (3, 2073, 6, CAST(N2016-09-17 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (4, 2073, 7, CAST(N2016-10-17 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (5, 2073, 8, CAST(N2016-11-16 AS Date)). ![]() INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (7, 2073, 10, CAST(N2017-01-14 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (8, 2073, 11, CAST(N2017-02-12 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (9, 2073, 12, CAST(N2017-03-14 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (10, 2074, 1, CAST(N2017-04-14 AS Date)). ![]() INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (12, 2074, 3, CAST(N2017-06-15 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (13, 2074, 4, CAST(N2017-07-16 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (14, 2074, 5, CAST(N2017-08-17 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (15, 2074, 6, CAST(N2017-09-17 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (16, 2074, 7, CAST(N2017-10-18 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (17, 2074, 8, CAST(N2017-11-17 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (18, 2074, 9, CAST(N2017-12-16 AS Date)). INSERT dbo.DatéLog (SNo, BSYear, BSMónth, EnglishDate) VALUES (19, 2074, 10, CAST(N2018-01-15 AS Date)).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |