Hi,
Yes, you can pass [Time] field value as a parameter to the function. If
Miladi2Shamsi
is a user-defined scalar function with one input parameter (
@EnDate
), then change
,[Time]
to this:
,[dbo].[Miladi2Shamsi]([Time]) AS [Time]
Query:
SELECT TOP 1000 [ShipToID]
,[StoreID]
,[TransactionNumber]
,[BatchNumber]
,[dbo].[Miladi2Shamsi]([Time]) AS [Time]
,[CustomerID]
,[CashierID]
,[Total]
,[SalesTax]
,[Comment]
,[ReferenceNumber]
,[DBTimeStamp]
,[Status]
,[ExchangeID]
,[ChannelType]
FROM [RMS2].[dbo].[PUBLIC_Transaction]